pMySQLServer lib
in [Visual Objects]
|
Prev: SetSelectiveRelation
Next: VO 2.8 - Wait state
From: Biagio on 31 Mar 2007 08:20 Hi to all, pMySQLServer works fine, a powerfull library to migrate to MySql. If I won't link two tables with a natural join like: SELECT d.sogg_id,s.sogg_nome FROM sedi AS d JOIN sogg AS s WHERE d.sogg_id=s.sogg_id the pMySqlServer shows a error (....GetTblPkFields ) A idea to solve the problem? Thanks Biagio
From: Apolonio Luis Medina on 31 Mar 2007 18:25 Biagio, I do not receive error with an similar query. You already tested your query in some client of mysql. What exactly you want to do with this query? Probably you are thinking as if they were DBF tables, and you suppose that the JOIN is required to show fields of two tables. Apolonio Luis Medina Sonora, Mexico
From: Jeff Williams on 1 Apr 2007 00:40 Try this SELECT d.sogg_id,s.sogg_nome FROM sedi AS d JOIN sogg AS s ON d.sogg_id=s.sogg_id Regards Jeff Biagio wrote: > Hi to all, > > pMySQLServer works fine, a powerfull library to migrate to MySql. > > If I won't link two tables with a natural join like: > > SELECT d.sogg_id,s.sogg_nome > FROM sedi AS d JOIN sogg AS s > WHERE d.sogg_id=s.sogg_id > > the pMySqlServer shows a error (....GetTblPkFields ) > > A idea to solve the problem? > > Thanks > > Biagio >
From: Klaus on 1 Apr 2007 04:54 Hi Biagio, please, show the exact errormessage (linenumber), i'll take a look into the Method GetTablePkFields regards Klaus On 31 Mrz., 14:20, "Biagio" <softw...(a)notario.it> wrote: > Hi to all, > > pMySQLServer works fine, a powerfull library to migrate to MySql. > > If I won't link two tables with a natural join like: > > SELECT d.sogg_id,s.sogg_nome > FROM sedi AS d JOIN sogg AS s > WHERE d.sogg_id=s.sogg_id > > the pMySqlServer shows a error (....GetTblPkFields ) > > A idea to solve the problem? > > Thanks > > Biagio
From: Biagio on 1 Apr 2007 06:59
Hi, this is the code //------------------------------------------------------------------- METHOD ReadRecord() CLASS Tabelle_BaseWin IF ! SELF:oDCbBrowser1:Server=NULL_OBJECT .and. SELF:oDCbBrowser1:Server:Used SELF:oDCbBrowser1:Use() ENDIF SELF:cSqlQry := String2Psz("SELECT d.sogg_id,s.sogg_nome FROM sedi AS d, sogg AS s WHERE d.sogg_id=s.sogg_id") SELF:oServer := pMySqlServer{SELF:cSqlQry,SysObject():SqlConn} SELF:oDCbBrowser1:Use(SELF:oServer) RETURN //---------------------------------------------------------------- And this is the error ***********************ERROR******************************** CA-Visual Objects (Version 2.6.0, Build 1151), Version 2.6 01/04/2007 12.48.55 Application: c:\nb_app26\GestStudio.DBG Error message: -------------- Error Code: 19 [ VARIABLE NOT INITIALIZED ] Subsystem: BASE Function: IVARGET Argument: {(0x0000)0x00000000} CLASS CallStack: PMYSQLSERVER:GETTBLPKFIELDS (Line: 17) PMYSQLSERVER:ADDTABLE2ALLTABLE (Line: 5) PMYSQLSERVER:GETSERVERSTRUCTUR (Line: 46) PMYSQLSERVER:INIT (Line: 22) TABELLE_BASEWIN:READRECORD (Line: 9) Error Object created: -------------------- SubSystem :BASE SubCode :0 GenCode :Variable not initialized OsCode :0 ArgType :NIL FuncPtr :0x00000000 ArgNum :0 FuncSym :IVARGET Severity :0 CanDefault :.F. CanRetry :.F. CanSubstitute :.T. Operation : Description : FileName : Tries :0 FileHandle :0 SubCodeText : Arg :{(0x0000)0x00000000} CLASS ArgTypeReq :NIL MaxSize :0 SubstituteType :NIL CallFuncSym : -------------------- If I change the query in SELECT d.sogg_id,s.sogg_nome FROM sedi AS d JOIN sogg AS s ON d.sogg_id=s.sogg_id I have the same error !!!! In a standard client application as HeidiSQL all works fine Thanks Biagio Klaus ha scritto: > Hi Biagio, > > please, show the exact errormessage (linenumber), i'll take a look > into the Method GetTablePkFields > > regards > Klaus > > On 31 Mrz., 14:20, "Biagio" <softw...(a)notario.it> wrote: > > Hi to all, > > > > pMySQLServer works fine, a powerfull library to migrate to MySql. > > > > If I won't link two tables with a natural join like: > > > > SELECT d.sogg_id,s.sogg_nome > > FROM sedi AS d JOIN sogg AS s > > WHERE d.sogg_id=s.sogg_id > > > > the pMySqlServer shows a error (....GetTblPkFields ) > > > > A idea to solve the problem? > > > > Thanks > > > > Biagio |