General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Thank you for reply.
>
>you right , INLIST only let you have 24 items in the List. Any way I already have tryied the cursor, but it does not seems to work.
>
>can you take a look at this and tell me,Am I doing anything wrong?
>
>this is what i did:
>
>CREATE CURSOR SQL_Sem (sem_Names C(25))
>
>for i = 1 to thisform.selectedlist.listcount
> INSERT INTO SQL_Sem (sem_Names);
> VALUES (thisform.selectedlist.ListItem(i))
>endfor
>
>select all a.cid, a.cname, b.csemester, b.ccourse, b.ccouroff, b.cstudent from sys_mast a, enroll b where a.cid = b.cstudent and rtrim(b.csemester) in (select sem_Names from SQL_Sem) into dbf c:\attend\temp
>
>when I brows the temp table, it is empty.
>
>thank you again:)
As well as what Vlad mentioned you might try suspending the program execution just before the SQL statement and examing the cursor file that you built to ensure that it is exactly what you expect it to be.
Good Luck,
REM
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only