Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement