Search results for query: *

Olaf, Originally UTKVAL1 and UTKDESC come from 2 different tables which I put in to temporary cursor that is eventually going to a CSV file. It’s not a permanent table that I am manipulating.

Thanks Imaginecorp! It works.

There error occurs when UTKDESC2 (field) is blank/empty. The error is: Syntax error

UTKDESC (field) and UTKDESC2 (field) are my captions for UTKVAL1 (field) and UTKVAL2 (field). Sometimes UTKDESC2 is blank (nothing in the field). When this happens I receive an error. UTKDESC (field) is the caption field. The data in this is variable. Example: Test1 UTKDESC2 (field) is...

Hello Imaginecorp. If I use this code (which works - thank you Imaginecorp): where not empty(UTKVAL2) ; Then the code will ignore the whole record. I still want to see the record just basically ignore the column that is blank. :)

UTKDESC (field) and UTKDESC2 (field) are my captions for UTKVAL1 (field) and UTKVAL2 (field). Sometimes UTKDESC2 is blank (nothing in the field). When this happens I receive an error. This what I'm trying to handle.

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

Thanks Imaginecorp! That worked.

Yes, UTKDESC is a column/field currently. I want to do is use whatever is in that column/field as the header for UTKVAL1 when I create the CSV file. Example Code: SELECT CUSID AS "CUSTOMER_ ID",; UTKVAL1 AS "Whatever was in the field UTKDESC",; FROM trda; INTO CURSOR Trak1a SELECT Trak1a...

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

Is there away to access the color pallet so I can let the user choose colors from there?

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!

Thank you Skip! That worked.

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...

Is there any way to create a button on the tool bar or create a shortcut, or shortcut keys to automatically add a background to a PDF?

I purchased SOFPRO's PCGUARD and it work great. Thank you everyone for your responses.

Yes, I have written a VFP9 program to create graphs in my report. In the line graph portions I have use the following lines. .SeriesCollection[1].DataLabels.Orientation = 60 .SeriesCollection[1].DataLabels.Position = 0 && top .SeriesCollection[1].DataLabels.HorizontalAlignment = 1...

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?

Thank you CajunCenturion and white605 I'll take alook.