Hi Al.
I have tried some of your suggestions to no avail.
However I have gone further and found the problem.
I take a CSV file and create a table with field names based on the CSV header record.
I then go and map the label field names to the CSV field names.
Then I use the following code to change the field names in the table...
IF LOWER(THISFORM.lcName) <> 'name'
IF THISFORM.lcName = 'Nothing' OR THISFORM.lcName = ''
ALTER TABLE (temp1) ADD COLUMN name c(70) NULL
ELSE
ALTER TABLE (temp1) RENAME COLUMN (THISFORM.lcName) TO 'name'
ENDIF
ENDIF
...in development THISFORM.lcName has a correct value and the code after the ELSE is executed, however within the EXE, THISFORM.lcName has lost its value and runs the code prior to the ELSE.
Still trying to work out why the form property should lose its value while staying within the form.
Thanks
>>Hi,
>>
>>I have a simple label printing program that outputs to A4 laser paper labels.
>>
>>When in development the labels preview and print OK, but as soon as I run from the exe, the first page just displays the third field of the label for the very first record and nothing else.
>>
>>There are 429 records in the table (as shown on the preview status bar) and label preview allows me to view a total of 31 pages all blank except for that 1 field from the very first record.
>>
>>Spent quite a bit of time on this, trying various things.
>>
>>Any ideas would be greatly appreciated.
>
>Are you testing EXE vs. development on the same computer, logged in as the same user account?
>
>What do you get if you try printing just a few, or even just 1, label from the EXE (rather than 429)?
>
>Do you have another (different) printer you can print to for test purposes?
>
>Are there any images in the labels? If so, are the images available as separate disk files or are they built in to the EXE?
>
>A SWAG, but if your EXE and dev/test folders are different, with different FOXUSER files, try renaming the ones with the EXE.