problem type ratings in VA integration

vaccaro · Post by **vaccaro** » Mon Oct 08, 2007 5:46 pm

Hi,
When I try to manage the type ratings via remote integration
By pilot, I get this error

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'Select ACDB_ID from FlyNET_Aircrafts where Owner = 'Air Mermaid

When I try the other way, on the fleet section the drop down list is empty.

Airline: Air Mermaid [1065]

Cheers,

Post by **oge978** » Mon Oct 08, 2007 10:42 pm

Hi ,

I'm aware the matter (and some others) which are due to a version mismatch between MySQL 4.1 and 4.0 ...

If I can find some really free time I will change the codes .

Technically MySQL 4.0 do not support subqueries , but 4.1 and upper does like MsSQL . To prevent any furthers incomp. I will use more standard codes

Thanks for pointing this out and waiting .

vaccaro · Post by **vaccaro** » Mon Oct 08, 2007 11:11 pm

Ah! OK.
Actually not really a problem 'cos we don't have many a/c.
I thought it was only me having the problem.
Teşekk