Kay, thanx for all your help. I have been applying what you posted, and
things seem to be working.
Regards,
Mark
--
View this message in context:
http://www.nabble.com/How+to+manage+large+SQL+data+sets+-+reply+2-t1565790.html#a4477959
Sent from the Revolution - User forum at Nabble.com
On 5/6/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
How do I get the data into a table list on the card?
As David has indicated all the info is in the Docs.
From the Rev Docs
revDatabaseColumnNamed(recordSetID,columnName[,holderVariable])
revDatabaseColumnNamed(myResults,"LASTNAME")
On 06/05/2006, at 4:22, <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> wrote:
Ruslan wrote:
RevDataFromQuery -- is not good choice in your case.
it load everything into string of result
You need to use RevQueryDatabase
==
The successful use of this command retur
Ruslan wrote:
RevDataFromQuery -- is not good choice in your case.
it load everything into string of result
You need to use RevQueryDatabase
==
The successful use of this command returns an integer, not the data.
How do I get the data into a table list on th
On 5/5/06 7:19 PM, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
> Ruslan, here's my script:
>
> global tConnectID,tCursorID,mySelection
>
> on selectNames
> if the label of button "NameViewOption" = "Active Names" then
> put "SELECT last_name, first_Na
Ruslan, here's my script:
global tConnectID,tCursorID,mySelection
on selectNames
if the label of button "NameViewOption" = "Active Names" then
put "SELECT last_name, first_Name, address, city, state, zip_code, phone_no
FROM names WHERE active_flag = 'T'
On 5/5/06 6:33 PM, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
Hi Mark,
> Hi all,
>
> How do I manage in Studio 2.7.1, large sets of SQL data?
>
> I have over half a million records in a MySQL table (just name, address, and
> phone number), and plan on building an application in Studio to ac
Hi all,
How do I manage in Studio 2.7.1, large sets of SQL data?
I have over half a million records in a MySQL table (just name, address, and
phone number), and plan on building an application in Studio to access this
data. But so far, I've not been able to get past Studio hanging/freezing when
