General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>Native data Senario.
>>localcur
>>select somefields from mytable where mytable.keyfield in (select keyfield from localcur)
>>the above works fine with native VFP data.
>>
>>SQL data senario
>>localcur
>>*** the localcur can not be used in SQLEXEC, therefore i populate the data into an array:
>>select keyfield from localcur into array myarray
>>Is there an SQL syntax similar to:
>>sqlexec(lhandle,[select somefields form mytable where myrable.keyfield in myarray)
>>Please note: I would like to avoid the creation of a string with data from the array.
>
>Nope, you can't do that.
>But you can create an SQL query that would return you the same results using only SQL Server tables.
Hi Boris,
What kind SQL query. SQL cannot see the cursor I created at runtime ?
Previous
Next
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