Information générale
Catégorie:
Codage, syntaxe et commandes
>>>You can not use parameter the way you're using. The SELECT * from tableName should be send as is, e.g.
>>>
>>>sqlCommand = 'select * from ' + tableName + ';'
>>>
>>>You can probably send several commands at once and use multiple result sets (say, do 10 tables in one command).
>>
>>
>>That worked. Now how to deal the the Copy to variable?
>
>What exactly do you mean? What is your new code and what do you need help with?
Once I have the complete table in the cursor I want to copy that data to a foxpro table
2 more steps needed
1) Identify the table name Ex arjob
2) Copy the cursor to c:\a\arjob as a foxpro DBF
I believe Copy To by default goes to a DBF
Précédent
Suivant
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