I have a UNION statement I am working with and need to place hold fields that are used in the second SQL statement in the first.
I was adding assignment lines in #1 to the SQL such as....
Select ;
0 as holdint, ;
'' as holdtext, ; actually this is two double quotes
{//} as holddate, ;
0.00 as holdnum, ;
etc
Is the assignment of 0 in holdint set that field/variable to an integer or a numeric?
The holdtext apparently the #2 SQL is a field that is 30 characters long. I think this may be giving me a INCOMPATIBLE UNION error. I think I need to specify a length for this holder in #1 but not sure how. I thought about adding a LOCAL variable but again, not sure how to declare the length (other than typing 30 spaces which I don't like.)
Suggestions - help !!!!!!
Thanks
Peter Brama
West Pointe Enterprises
VFP is getting easier but STILL alot to learn!!