General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2003 Server
>>I am using SQL passthtrough to retrieve records via the sqlexec command
>>is there a way to limit the number of records returned... i.e. the first 5 for example.
>>
>>I am only pulling them to view the data to make a decision on whether to pull all of the data...
>>
>>User doesn't want to wait for the full table to come across the network...
>>
>>Some tables have millions of records!
>>
>>Only need a few to help decide if they want all of them...
>
>Mike,
>
>Check SPT cursor fetching and progress displaying for SPT cursor downloading FAQ #8150
>In general, it's not a good idea to pull whole table. You should design your application in such way so user can specify the records they need and than bring only those back.
Thanks for the help and advice, however I will need to pull all of the data eventually as I will be moving the data from one database to another when completed. I just wanted to allow the user to view sample data to aid in deciding how to transfer the data. The new system has fields with different names...
On a slightly different note: Is it possible to do use tableupdate and table revert commands with sql passthrough... I cannot set up remote views on the data as, it doesn't work properly, whereas sql passthrough gets the data...
My experience with sql passthrough has always been of the reqad only variety and I have never had to update data before..
Thanks for all of your help... I'll go read that FAQ now...
Mike
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only