Peek Function on Field with spaces or Chars

[rustyfishbones]

Hi All,

I have a SQL SELECT Statement and I want to use peek to get the last record loaded

My field is called booking-no, so I need to use "", but the peek function does not like the double quotes.

How can I get around this for the first parameter in the peek function

[#2 · Accepted solution]

use only single quote.

let booking = peek('booking-no ',-1,'booking ');

[rustyfishbones]

Hi radha,

I tried that originally and I got no result so assumed that it was because of the - between booking-no

It seems to be working with just the single quotes but definetly was not earlier today

Thanks

Regards

Alan

[#4]

you are done table ascending order before use peek function.

[sunny_talwar]

and I would not leave any spaces after booking-no just to make sure I am not leaving any loose ends:

LET booking - peek('booking-no', -1, 'Booking');

[#6]

load * resident <table name> order by <field name> asc

here now aplly peek function.

[rustyfishbones]

thanks radha,

I have created a tmptable for sorting and dropped the table

Regards

Alan