Re-2: Where and how do you store SQL command

2007-12-27 Thread runrev260805
Thanks for the suggestions. For now, i will use a text field in a hidden stack. But for the future version of my app, which will allow the user to select the field/rows, which should be selected from MS SQL server , i will use custom properties. All the best, Matthias

Where and how do you store SQL command

2007-12-19 Thread runrev260805
Hi, i have to read data from a MS SQL Server under Windows using ODBC My select statement is about 60 lines in size. I created a text field and put the sql commands in it. Is there a better way to do this? Where would you store that statement? In the rev script? If so, how would you store the

Re: Where and how do you store SQL command

2007-12-19 Thread Klaus Major
Hi Matthias, Hi, i have to read data from a MS SQL Server under Windows using ODBC My select statement is about 60 lines in size. I created a text field and put the sql commands in it. Is there a better way to do this? Where would you store that statement? In the rev script? If so, how

Re: Where and how do you store SQL command

2007-12-19 Thread Ian Wood
On 19 Dec 2007, at 12:54, [EMAIL PROTECTED] wrote: My select statement is about 60 lines in size. I created a text field and put the sql commands in it. Is there a better way to do this? Where would you store that statement? Personally I tend to put really long selects (and AppleScripts)

Re: Where and how do you store SQL command

2007-12-19 Thread Jim Ault
On 12/19/07 5:08 AM, Ian Wood [EMAIL PROTECTED] wrote: Personally I tend to put really long selects (and AppleScripts) in text fields on a hidden stack, as it makes it extremely easy to edit them in the future. Editing custom properties is just as easy as a field (in fact better) by doing