SqlSelect doesnt wanna work

[Vansh Singh]

Sorry, I don't understand all your questions, am new to Valentina. I am
running Director MX 2004 and the OS I have here is Win XP. The V4md.x32
xtra file has a datestamp of 11/3/2008 

Reading the pdf doc for V4MD_reference, I turned on the Debuglevel, but
there is no V4MD_Logn.txt generated.

_global.update_db=the moviepath&"database_update\"
_global.gDatabase.Open(_global.update_db&"music_source.vdb" )
_global.gDatabase_target.Open(_global.thedrive & "db\music_source.vdb" )
target_db_path=_global.thedrive & "db\"

reindex_result = _global.gDatabase_target.SqlExecute( "REINDEX DATABASE"
)

if reindex_result <> 0 then
  --re-index has been unsuccessful, quit the program
  Alert("Re-indexing failed, the program will now quit.")
  quit
else
  Alert("hey 123")  
end if

_global.Valentina.debugLevel = #kLogNothing

sqlstring = "SELECT ID FROM ATTR where sys_id=2015"

sql_result = _global.gDatabase_target.SqlSelect(sqlstring)
Alert(_global.Valentina.lastError)


I get an alert box for 'hey 123' and then it goes quiet.

Vansh

-----Original Message-----
From: valentina-bounces+vsingh=us.counterp.com at lists.macserve.net
[mailto:valentina-bounces+vsingh=us.counterp.com at lists.macserve.net] On
Behalf Of Ruslan Zasukhin
Sent: Friday, January 30, 2009 12:19 PM
To: valentina at lists.macserve.net
Subject: Re: SqlSelect doesnt wanna work

On 1/30/09 10:06 PM, "Vansh Singh" <vsingh at us.counterp.com> wrote:

Hi Vansh,

> I am dealing with multiple open databases. I have a piece of lingo
code
> that opens one database. I have a sqlExecute that works fine on this
> open database. Right after this, I am trying to run a sqlselect on
same
> database and that does not work at all. The program just doesn't do
> anything; it just hangs. I have tried using everything I can think of.
I
> put in an alert for Valentina.lastError and it doesn't show anything.
No
> alert box pop at all.

* so multiple dbs or single?

* no vserver ?

* you can set Valentina.DebugLevel and check log file.

* no info about OS version ...




-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]


_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina