How do I handle blank fields with CAST?
My code:
SELECT CUSID AS CUSTOMER_ ID,;
CAST(UTKVAL1 AS C(50)) as (UTKDESC),;
CAST(UTKVAL2 AS C(50)) as (UTKDESC2); && UTKDESC2 can be blank.
FROM trda;
INTO CURSOR Trak1a
Thanks!
CJ
How do I create a CSV file with variable column names?
SELECT CUSID AS "CUSTOMER_ ID",;
UTKDESC,; <--- The value in this field I want to use as my caption for the field below it.
UTKVAL1,;
FROM trda;
INTO CURSOR Trak1a
SELECT Trak1a
COPY TO \XReports\EXPTEST.CSV FIELDS CSV
Thanks!
CJ
I am new to Flash. I have a presentation I am putting together. I need a button to open a Flash Paper (Flash Papers 2) .
How do I do this?
Does anyone sell premade buttons?
Thanks!
This problem has occurred recently.
I have 3 cell. Cells A and B are the numbers to be added together and cell C is the result it calculates of cells A and B
Normally all I have to do is change the number of one of the first 2 cells and the third cell is automatically updated.
BUT, now when...
Hello.
Does anyone know how to set the firewall in AVG 8 to work with the peripherals attached to the Belkin Network USB Hub?
I am able to connect with the peripherals (example jump drive) with the firewall turned off.
I have created a service for the TCP/UDP to 19540.
What else do I need...
On a line graph is there away to automatically place the DataLabel above or below the point of the “V” so that the label is not printed on top the line?
I have VFP 9 and currently I use Crypkey (purchased years ago), but I can only license one product and upgrades for Crypkey are too expensive.
I have been looking at SOFPRO. Their pricing looks good and I would be able to license more than one product. Is their product good?
I would like to...
What software is available to print from the Palm (Treo 680)?
I've looked at PrintBoy, but it's been over a month of trying to get into contact them and they don't respond.
So what else is available?
Thanks!
We are having a problem with sending messages in Outlook 2003.
Outlook is ramdomly sending a messages multiple times to the recipient. Since it's random I am unable to determine what is causing Outlook to do this.
I have updated Outlook with the most recent updates.
Any ideas?
Thanks!
Jon
We are using a PDA connection to our VFP programs via Terminal Services and Citrix.
Is there away to shrink the screen size to fit the PDA screen dynamically?
I’m trying to add a Data Table to my graph on my report. Which I am able to do.
The problem is forcing the Data Table to appear on the graph without having to BROWSE the table and CLICK the graph to update.
How do I do this?
Thank you,
Jon
CODE BELOW:
****...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.