General information
Category:
Coding, syntax & commands
Environment versions
Network:
Windows 2000 Server
>Hi all,
>
>I have a dbf and when i export this file with a select and copy to type xls some results are changed. for ex intead of 10 i have 1,7977E+308 how do i solve this problem so i get 10 instead of 1,7977E+308.
>
>thnx
>
>this is my select :
>
>SELECT IIF(DELETED(),'Gewist','Actief') as 'Gewist', hf_nr as 'Factuur_Nr',hf_doc as 'Type_Doc',hf_klt as 'Klantnummer',hf_dat as 'Datum',df_grc as 'Groep',;
> df_art as 'Artikel',df_kort as 'Korting',df_oms as 'Omschrijving',IIF((EMPTY(df_aant) or (df_aant == 0)),1,df_aant) as 'Aantal',df_vke as 'Verkoopseenheid',IIF((EMPTY(df_bakken) OR (df_bakken ==0)),1,df_bakken) as 'Eenheid',;
> IIF((EMPTY(df_aant) or (df_aant == 0)),1,df_aant) * IIF((EMPTY(df_bakken) OR (df_bakken ==0)),1,df_bakken) as totaal FROM ;
> f_hfpx LEFT JOIN f_dfpx ON hf_nr = df_nr INTO CURSOR qryInvoice
>
>Afther some test i've seen that the problem is caused by the iif statment. Somebody has a solution for this problem ?
SELECT , with 2 or more tables, don't support DELETE()
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only