Hi,
I want to add a property that I selected from a relational database to my neo4j graph wchich is already created from my relational database. But the set property doesn't work for me. despite it doesn't give me an error and when I check the relationships I didn't find the property created
could some one help me please to rectify the query
The set syntax is correct. Have you verified you are getting rows returned from the load jdbc call? If so, have you verified you are getting matches?
Just a note, the with statements on lines 6 and 8 should not be necessary.
Thank you for you response,
Yes Ihave 18 commited lines which is correct but the propertiesSet:0
When I check the match using reel dat_deb and dat_fin and origin ID ans destination ID numbers returned by my select query I get the relationship in my graph
I also parse the dates returned by the sql query to be able to compare them to my localdatetimes dates in neo4j but always properties are not setted
This might seem silly, but have you tried removing the "new line" characters so that highlighting between the single quotes works? I've found that sometimes a random character causes a break in the quoted syntax, which then doesn't work like I expect it to.
It won't be clean to read, but at least the syntax highlighter will show anything unusual.