topic-30929

Board index FiveWin for Harbour/xHarbour Check Existing VIEW in MySql

dutch

Posts: 1598

Joined: Fri Oct 07, 2005 05:56 PM

Check Existing VIEW in MySql
Posted: Fri Jun 19, 2015 06:00 AM

I try FW_AdoTableExists( "VIEWTABLE", hb_GetAdoConnection() ) but it return Fault (.F.)

How to check the existing VIEW in MySql

Thanks in advance.

Regards,

Dutch

FWH 2304 / xHarbour Simplex 1.2.3 / BCC73 / Pelles C / UEStudio

FWPPC 10.02 / Harbour for PPC (FTDN)

ADS V.9 / MySql / MariaDB

R&R 12 Infinity / Crystal Report XI R2

(Thailand)

AHF

Posts: 838

Joined: Fri Feb 10, 2006 12:14 PM

Re: Check Existing VIEW in MySql
Posted: Fri Jun 19, 2015 07:04 AM

Dutch,

View its not in schema as table but as view.
That function as well as ADORDD hb_adoRddExistsTable( oCon,cTable, cIndex ) only checks the schema for table or index.
As soon as I can Ill change it to hb_adoRddExistsTable( oCon,cTable, cIndex, cView ) also check views.
In meantime you can workaround like:

Code (fw): Select all Collapse

TRY
  CREATE VIEW
CATCH
   ADOSHOWERROR( oCon )
END
SELE 0
USE VIEW

Ill keep you posted.

Regards

Antonio H Ferreira

AHF

Posts: 838

Joined: Fri Feb 10, 2006 12:14 PM

Re: Check Existing VIEW in MySql
Posted: Fri Jun 19, 2015 07:39 AM

Dutch,

Please send me your email to disal.antonio.ferreira+gmail.com

Regards

Antonio H Ferreira

FiveTech Support Forums

Continue the discussion