Hi Guys,
Can anyone tell me if advantage 11.10 is supported in Alaska with
Alaska's native Select statement. eg

Select * from mydatabase via mysession

mydatabase is a properly pathed table name
mysession is a proerly formatted connection to the Advantage Server.

Am I missing something or is this not supported.

This is a simple statement in advantage works with no problems, but
without the added bagage of the 'Via' element, so please tell me howto
make this work with same simple code that advanatge uses.

Regards

Chris

Chris,

  What seems to be the problem? Are you getting an error 
of some sort?

The SQL SELECT command still has limitations in the current
version, but queries such as yours should work.

You could also try the following code:

  oStmt := DacSqlStatement(mySession):fromChar("Select * from mydatabase"):build()
  oStmt:query(, "myquery")

I hope this helps.

Regards,
  Till Warweg
  [Alaska Software]

--------------------------------------------------------------------
Technical Support:         support@alaska-software.com
News Server:                 news.alaska-software.com
Homepage:                     http://www.alaska-software.com
KnowledgeBase:            http://www.alaska-software.com/kb
--------------------------------------------------------------------



"Chris Chambers" schrieb im Newsbeitrag news:9fpfcade2fc137rq7lq7ptaqj0idao67cn@4ax.com...
> 
> Hi Guys,
> Can anyone tell me if advantage 11.10 is supported in Alaska with
> Alaska's native Select statement. eg
> 
> Select * from mydatabase via mysession
> 
> mydatabase is a properly pathed table name
> mysession is a proerly formatted connection to the Advantage Server.
> 
> Am I missing something or is this not supported.
> 
> This is a simple statement in advantage works with no problems, but
> without the added bagage of the 'Via' element, so please tell me howto
> make this work with same simple code that advanatge uses.
> 
> Regards
> 
> Chris

Thank You Till.
That is much appreciated, I will try it and see how it works and will
let you know.
Regards
Chris

On Thu, 29 Jan 2015 15:23:31 +0100, Till Warweg wrote:

>Chris,
>
>  What seems to be the problem? Are you getting an error 
>of some sort?
>
>The SQL SELECT command still has limitations in the current
>version, but queries such as yours should work.
>
>You could also try the following code:
>
>  oStmt := DacSqlStatement(mySession):fromChar("Select * from mydatabase"):build()
>  oStmt:query(, "myquery")
>
>I hope this helps.

Sorry Till,
This does not work.
Regards
Chris

On Thu, 29 Jan 2015 15:23:31 +0100, Till Warweg wrote:

>Chris,
>
>  What seems to be the problem? Are you getting an error 
>of some sort?
>
>The SQL SELECT command still has limitations in the current
>version, but queries such as yours should work.
>
>You could also try the following code:
>
>  oStmt := DacSqlStatement(mySession):fromChar("Select * from mydatabase"):build()
>  oStmt:query(, "myquery")
>
>I hope this helps.

Chris,

  What happens? What kind of error do you get?

Regards,
  Till Warweg
  [Alaska Software]

--------------------------------------------------------------------
Technical Support:         support@alaska-software.com
News Server:                 news.alaska-software.com
Homepage:                     http://www.alaska-software.com
KnowledgeBase:            http://www.alaska-software.com/kb
--------------------------------------------------------------------



"Chris Chambers" schrieb im Newsbeitrag news:fcfadahflvjqgtv26iokvol3079ce4i3sj@4ax.com...
> Sorry Till,
> This does not work.
> Regards
> Chris
> 
> On Thu, 29 Jan 2015 15:23:31 +0100, Till Warweg wrote:
> 
>>Chris,
>>
>>  What seems to be the problem? Are you getting an error 
>>of some sort?
>>
>>The SQL SELECT command still has limitations in the current
>>version, but queries such as yours should work.
>>
>>You could also try the following code:
>>
>>  oStmt := DacSqlStatement(mySession):fromChar("Select * from mydatabase"):build()
>>  oStmt:query(, "myquery")
>>
>>I hope this helps.