Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Category:
Coding, syntax & commands
>Please help:
> I'm trying to create a universal data import table based upon the content of another table I call 'schema'. Schema contains the field names, length, type and start and end points of the fields to be imported from a ASCII file. I'm hung up on creating the new data table using just variables to declare the fields. Here is my latest version of code, and it keeps erroring out on the "Alter Table" command.
>
>I really appreciate your help.
>
>Bob Ohrstedt
>RJO Associates
>
>LOCAL lcfile, lcalias, lcreclen, lafields
>
>IF NOT USED('schema')
> USE schema IN 0 SHARED
>ENDIF
>
>CREATE TABLE OhioStreets(fieldnum I(4))
>
>IF NOT used('OhioStreets')
> USE OhioStreets IN 0 EXCLUSIVE
>ENDIF
>SELECT schema
>
>GO top
>
>
>lcfields = ""
>SELECT schema
>SCAN
>
> lcFieldName = schema.desc
> lnLength = schema.length
> lctype = schema.type
>
> ALTER TABLE add column &lcfieldname &lctype(lnlength)
>
>LOOP
>EXIT
>ENDSCAN
Robert,
Was is the value of lcType at the time the Alter Table is issued?
Renoir
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