>Sorry, i click the send button
>
>Here my probleme
> I want to pass a sql command in a variable an execute them.
> I dont want to use sqlexect() or a listbox
>
>Someone told me i can use macro but i dont understand how.
>
>Somebody can help me??
>
>code :
> strsqlselect = "selet * from table into cursor cursqltemp1"
If you don't know how to use the macro substitution, it works like this:
SQLCommand = "select * from Table into cursor Temp1"
&SQLCommand
HTH,
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)