File Naming Issue

[jwsjrmba]

Here is my issue.

I have five .dbf files. I want them to be saved as application files with the "client number".dbf I am storing the client number to variable "clientnumber" I want to do the following

open database temp
use table1 excl
copy structure to "clientnumber".dbf

Confused, thanks in advance for any assistance you might be able to give.

John

 

[baltman]

copy structure to (clientnumber)

from help:

"When you store the name to the variable or array element, you can substitute the name into a command or function by enclosing the variable in parentheses."

 

[GriffMG]

Like this:

m.tablename = "clientnumber"
open database temp
use table1 excl
copy structure to (m.clientnumber)

Regards

Griff
Keep [Smile]ing

 

[GriffMG]

Dooh, sorry

m.tablename = "001020345"
open database temp
use table1 excl
copy structure to (m.tablename)

Regards

Griff
Keep [Smile]ing