Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
actually, what I'm trying to do in this step is very easy:
- I have a list of bookings from our Database that were done on one specific box.
- Each of those bookings has a date-time-stamp
- I have one date-time-stamp and I want to get all bookings on that box that were done before
=> To be able to compare it, I have put the numeric equivalent of that date-time-stamp into a variable
=> In the next LOAD I `have included a WHERE clause, specifying that num([date-time-stamp]) < '$([variable])'
However, that doesn't work: I do get some bookings - but including the one with that date-time-stamp and that name - I wanted to exclude that and get only those that were done strictly before that (operator < )
=> I thought that it might be because of the quotes and I removed them
=> Then the log said "Garbage after statement"
I post here the last few lines from the log so you know what I am talking about.
16.12.2014 11:17:52: 0600 NoConcatenate
16.12.2014 11:17:52: 0601 Trans_Dtl2:
16.12.2014 11:17:52: 0602 LOAD
16.12.2014 11:17:52: 0603 Tran_Date_v1 as Tran_Date_v4,
16.12.2014 11:17:52: 0604 User_Signon_v1 as User_Signon_v4,
16.12.2014 11:17:52: 0605 Tracking_Nr_v1 as Track_Nr_v4,
16.12.2014 11:17:52: 0606 QUANTITY as Qty_v4
16.12.2014 11:17:52: 0607 RESIDENT Transaction_Details_pre
16.12.2014 11:17:52: 0608 WHERE Tracking_Nr_v1 = 'B3D254'
16.12.2014 11:17:52: 0609 AND num(Tran_Date_v1) < 41974,27712963
16.12.2014 11:17:52: 4 fields found: Tran_Date_v4, User_Signon_v4, Track_Nr_v4, Qty_v4, 1 lines fetched
16.12.2014 11:17:54: Error: Garbage after statement
16.12.2014 11:17:54: General Script Error
16.12.2014 11:17:54: Execution Failed
16.12.2014 11:17:54: Execution finished.
Can anybody help me there?
Best regards,
DataNibbler
Hi DataNibbler,
I think it's the comma in num(Tran_Date_v1) < 41974,27712963 - use instead a point num(Tran_Date_v1) < 41974.27712963
- Marcus
Could you share the whole of the load statement and a few statements after that as well ?
Hi DataNibbler,
I think it's the comma in num(Tran_Date_v1) < 41974,27712963 - use instead a point num(Tran_Date_v1) < 41974.27712963
- Marcus
Hi Marcus,
that is placed automatically based on that SET command on the Main tab, no? So I'll have to replace it.
Thanks a lot!
You could replace the '$([variable])' part with something like num#('$([variable])'). Should handle the different format....
Peter