Source language: Translate to:

Open only a part of the recordset

Questions about our Advanced Database plug-in

Moderator: Neosoft Support

Open only a part of the recordset

Postby stu » Fri Jan 16, 2015 10:26 am

Hi there!

I'm working with an SQL Server db with several tables way over the 200K records. Problem I'm experiencing is that the dbpOpenTable's are taking forever for this particular record sets... is there a way of opening a portion of the tables only and get info on demand...

Sort of a SELECT TOP 10 PERCENT (?)

Cheers.
User avatar
stu
 
Posts: 318
Joined: Wed Aug 07, 2013 11:37 am

Re: Open only a part of the recordset

Postby Neosoft Support » Fri Jan 16, 2015 11:27 am

Yes, you can use the dbpExecSQL action to open the table instead. For example, the following will open the table Contacts and display the first 50 records:

dbpExecSQL "AddrBook" "SELECT TOP 50 * FROM Contacts" ""
NeoSoft Support
Neosoft Support
NeoSoft Team
 
Posts: 5593
Joined: Thu Mar 31, 2005 10:48 pm
Location: Oregon, USA

Re: Open only a part of the recordset

Postby stu » Fri Jan 16, 2015 11:45 am

Neosoft Support wrote:Yes, you can use the dbpExecSQL action to open the table instead. For example, the following will open the table Contacts and display the first 50 records:

dbpExecSQL "AddrBook" "SELECT TOP 50 * FROM Contacts" ""


That's brilliant! Had no idea I could skip using dbpOpentable and go straight with execsql...

Just made my day! Thanks Dave!
User avatar
stu
 
Posts: 318
Joined: Wed Aug 07, 2013 11:37 am


Return to NeoBookDBPro

Who is online

Users browsing this forum: No registered users and 2 guests