>Hi Dorin
>
>>I've forgotten about string value returned. Maybe because type conversions between VFP and DBC driver, I don't know.
>
>Yeah I guess so. For Keys that is okay, but what will happen to the actual tables when returned thru the ODBC, like doubles, currencies, etc.?
Didn't had problems with that. Only with NOT NULL constraints and empty remote view records. This can be solved either by defining default vaues at remote view level or at database level (I choosed the last).
>
>Did you happen to refer the second problem I have posted?
>
Try:
CREATE VIEW myview remote as SELECT distinct MSALESREPS.*, ;
MSALESREPS_A.CNAME AS CSPONNAME, ;
MSALESREPS_A.CCITY AS CSPONCITY, ;
MSALESREPS_A.CCODE AS CSPONCODE ;
FROM MSALESREPS MSALESREPS ;
left JOIN MSALESREPS MSALESREPS_A ;
ON MSALESREPS.IID = MSALESREPS_A.IID ;
ORDER BY MSALESREPS.CNAME, MSALESREPS.CCITY
for avoiding duplicates
>Thanks for your help. I was told that you have a lot of experience with FireBird.
>
I don't have so much experience, but I've finished a projects and I currently work on another.
>Of course I won't be troubling you directly but if possible keep a lookout for "V6s5 & FireBird" subjects in Third Party, I will be posting my problems till I get a sample up and running <g>.
Ok.