operator/operand mismatch with dates -vfp/sql

[foxbldr]

Hi all,

I am using follwing sql statement to fetch date from sql server.

lcsql="select ......,{ d '1900-01-01' } as TEMP_DT..."

when I use following in my code,SOMETIMES, I get operator/operand mismatch error .

select lcCursor
do while !eof()
if TEMP_dt=date(yyyy,mm,dd) && error appears here

endif

enddo

I changed if statement to :
ttod(TEMP_dt)=date(yyyy,mm,dd), but still I get the error.

Any suggestions?


Thanks you all in advance.

 

[RickSchummer]

SQL Server does not have Date data types, only DateTime data types. What do you get when you list out the structure returned in the result set from SQL Server?


_RAS

http://www.whitelightcomputing.com

VFP MVP

 

[foxbldr]

RickSchummer,

I get the field(TEMP_DT) as a Datetime field.

Foxbldr

 

[MarciaAkins]

This is probably happening because temp_dt is a logical ( .F. ). Variables declared as LOCAL in scope are intitialized to .F. I suspect that therre is a flaw in your code that occasionally does not initialize temp_dt to a value and that is when you are seeing this error.



Marcia G. Akins

http://www.TightlineComputers.com

 

[RickSchummer]

Foxbldr,

What I was indicating in my message (obviously not as clear as I would have liked {g}) is that you comparison will never work since the time portion of the comparison will make it not be equal.

Double check the values passed into the DATE() function. I am guessing that YYYY, MM, and DD are the problem here.

_RAS

http://www.whitelightcomputing.com

VFP MVP

 

[RickSchummer]

Marcia,

Fancy meeting you here {g}.

Temp_dt is a column in the cursor retrieved via SQLExec() - well this is sort of an assumption based on the minimal code displayed in the initial message.



_RAS

http://www.whitelightcomputing.com

VFP MVP

 

[foxbldr]

RickSchummer,

Your assumption is correct. I use SQLEXEC function in a class(written in vfp 8) that connects to Sql2K server for retrieving data.

Actually, right part of my comparison is always
"Date(1900,01,01)" and VFP's TTOD function returns date from a datetime expression. Vartype(TEMP_DT)always returns "T"(datetime). It returns "T"(datetime) even with zero records in cursor.

My cursor is an updatable cursor and I update the field TEMP_DT. When the field value is the original value, I am executing some more code. i.e.

IF TTOD(TEMP_DT)=date(1900,01,01)
...........
..........
.......
ENDIF

tx

foxbldr

 

[RickSchummer]

foxbldr,

Stumped me. Without the actual data in front of me, with the basic assumption that Temp_dt is really a DateTime data type, your code should work fine.

Are you sure the error reported is for the correct line number? Are you popping into the debugger and checking out the environment?


_RAS

http://www.whitelightcomputing.com

VFP MVP