How doI get quoted field names?

[jpottsx1]

I need to generate put statement for a large number of database fields. I want to loop through creating the names of the fields and Data fields as follows;

Code: Select all

put revDatabaseColumnNamed(sRecordSetID,"Depress_Field_1") into field "Depress_Field_1"

I am having trouble with building the strings in the loop due to the existence Quotes and the need to create quoted statements.

I have tried:

Code: Select all

repeat with i = 1 to 10
put ",put revDatabaseColumnNamed(sRecordSetID,"&",UserField"& i&")into field"& ",UserField"& i
end repeat 

I cannot seem to get the generation of the field names quoted so that I can actually assign the fields and names properly

[Dixie]

Jeff,

I need to generate put statement for a large number of database fields. I want to loop through creating the names of the fields and Data fields as follows;

Code: Select all

put revDatabaseColumnNamed(sRecordSetID,"Depress_Field_1") into field "Depress_Field_1"

How about...

Code: Select all

put "put revDatabaseColumnNamed(sRecordSetID," & quote & "Depress_Field_1" & quote & ") into field " &  quote & "Depress_Field_1" & quote into myVar

be well,

Dixie

[BvG]

within sql calls you can also use single quotes (it's kinda hard to see ):

repeat with i = 1 to 10
put revDatabaseColumnNamed(sRecordSetID,'" & UserField & i &"') into field ("UserField"& i)
end repeat