Hi all
I have a problem with DBresult returned from JRDC2
I have on config.properties file the sql script
As you can see I exclude the records who have 'ΑΧΕ%' and 'ΑΧΓ%' and 'ΑΞΣ%'.
When I running the script on sql server I get the correct result.
But on my Android client I keep having records with 'ΑΧΕ%' and 'ΑΧΓ%' and 'ΑΞΣ%'.
Why that happening? I try all day to find out what is going on with it.
Any help appreciated.
Thank you
I have a problem with DBresult returned from JRDC2
I have on config.properties file the sql script
B4X:
SELECT ESFINote1.RegistrationDate, ESFINote1.DocumentCode, \
ESFINote1.ESFITradeAccountPeriodics_Debit AS xreosi, ESFINote1.ESFITradeAccountPeriodics_Credit AS pistosi, \
Case ESFINote1.ESFITradeAccountPeriodics_Credit when 0 then 1 else -1 end AS TheSing, ESFITradeAccount.GID, \
ESFITradeAccount.Code, ESFITradeAccount.Name FROM ESFINoteEntry_TradeAccountEntry_TradeaccountPeriodics ESFINote1 \
LEFT JOIN ESFITradeAccount on ESFITradeAccount.GID = ESFINote1.fTradeAccountGID \
WHERE ESFINote1.DocumentCode NOT LIKE 'ΑΧΕ%' AND ESFINote1.DocumentCode NOT LIKE 'ΑΧΓ%' \
AND ESFINote1.LineType in ('20', '25', '30') AND ESFINote1.DocumentCode NOT LIKE 'ΑΞΣ%' \
AND ESFINote1.fTradeAccountGID = ? ORDER BY ESFINote1.RegistrationDateAs you can see I exclude the records who have 'ΑΧΕ%' and 'ΑΧΓ%' and 'ΑΞΣ%'.
When I running the script on sql server I get the correct result.
But on my Android client I keep having records with 'ΑΧΕ%' and 'ΑΧΓ%' and 'ΑΞΣ%'.
Why that happening? I try all day to find out what is going on with it.
Any help appreciated.
Thank you