AnsweredAssumed Answered

Cant see all SQL records!

Question asked by benauerbach on Nov 6, 2011
Latest reply on Jun 23, 2016 by awier

Title

Cant see all SQL records!

Your post

Hello,

I am having trouble seeing all records from a external SQL table (running Filemaker Server 11 - news update).

 

If I am switching to the table view of the external SQL table I am only able to see a fraction of the records in this table. For example, if there are 100 records, as soon as I access the table I will be able to see 30 records. When I refresh the window I will be only able to see 6 records. While the window is being refreshed I can see he is sorting/finding more records, but when the refreshing process is finished 6 records will be shown. Before I was running the database on FileMaker 11 (not on the filmmaker server) where this didn't occur. 

 

I was thinking that this could be an issue of the open source SQL driver from actual technologies that I am using?

 

I am able to write records on the SQL table but if I want to delete all records it is not possible. Also searching through the records is not possible.

 

If I could get any advise, or hint I would be very thankful.

 

With kind regards,

Ben

 

Outcomes