Memo and sql

[twigs1981]

when I do the following:

SQLEXEC(PSI,'SELECT descript;
FROM BBSPECAL;
WHERE CFormFLDID=88 and LJOB=?
OrderNum', 'Results')

select Results
copy to array Resulted
thisform.txtLotNum.value = Resulted[1,1]


I displayed the cursor and it wasn't correct, it read memo... the descript col is a varchar(260) but the value in there is only 3 characters. anything obviously wrong here?

 

[rgbean]

Basically you can't continue character strings like this. Try:
SQLEXEC(PSI,'SELECT descript ';
+ 'FROM BBSPECAL ';
+ ' WHERE CFormFLDID=88 and LJOB=?OrderNum', ;
'Results')
OR
lcSelect = 'SELECT descript ';
+' FROM BBSPECAL ';
+' WHERE CFormFLDID=88 and LJOB=?OrderNum'
SQLEXEC(PSI, lcSelect, 'Results')

Rick

 

[twigs1981]

ooops... well that was a dumb mistake however it still reads memo when I complete the query and it is returning more tupples(2 actually) and I'm using the primary key...

 

[twigs1981]

also when I go into debugging it doesn't show the memo as being in the array where did the value go?

 

[twigs1981]

aight I the dba fixed the database as far as the primary key but still stuck getting the value of the memo in the array...when I do a select it shows memo and I can dbl click it to can see the appropriate value in there... but when I try to just access the array it is .F. .

forever stuck,
josh

 

[twigs1981]

after many unsuccessful attempts I got this:

SQLEXEC(PSI,'SELECT RTRIM(descript)';
+ 'FROM BBSPECAL ';
+ 'WHERE CFormFLDID=88 and LJOB='
+ 'OrderNum', 'Req')
BC_req = Req.exp


... new Q though.. how can I get rid of the cursor?

 

[chpicker]

[tt]USE IN Req[/tt]

Ian