FiveTech Software tech support forums

Marcelo Via Giglio wrote:Hello to all,

I am testing the FWH9.06 + xH from this distribution ADS Local 9.1

When I use temporary table, per example:

Code: Select all

SELECT clients.*, 0.0 as salary INTO #temp FROM clients

with previus version of RDD, like ADS 7.1 was possible to modify the
salary column like
(alias) -> salary := <value>

but with the last version this is not more possible I obtain a write error message.

I think this is a bug in the RDD, do you have the same problem?

Regards

Marcelo

                dbSelectArea( 0 )

                cSQL := 'select RRefDef.*, 0.0 as salary INTO #temp from RRefDef'

                IF AdsCreateSQLStatement( 'temp', ADS_CDX, hADS )

                   IF ADSExecuteSQLDirect( cSQL )
                      temp->salary := 1.1
                      xBrowse( 'temp', AdsVersion()  )
                   ELSE
                      MsgAlert(cSQL,'Unable to Execute SQL Statement - SQL Temp Alias')
                   END

                ELSE
                   MsgStop('Unable to Create SQL Statement', 'SQL Temp Alias')
                END
 

Marcelo Via Giglio wrote:Antonio,

thanks for your attention, this was a rare behavior that I found when I tryed to use the last RDDADS and temporary tables

Fraxzi

OK, thanks for your test, this mean that I have hope, because I exposed the same question in the xharbour's google group and they didn't have an logical answer for this issue

I will try again with xH 1.21 + ADS 9.1, I will post the results here thanks again

For me, work with ADS LOCAL is really usefull I don't know why other user don't use it, you can:

use sql (the best)
transparent crypt tables
ricth data type (graphics, money, etc)
Advanced and fast filter
Client/server (BUT YES this is expensive)
use PHP, PERL, CLIPXNET........ with ADS server
.......
......
ALL this with ADT or DBFCDX files


best regards

Marcelo

fraxzi wrote:I have my own version of that ADS issue...
There's no record on my created temp table when I xbrowse it.. no error. all successful execution.

Anyone sharing idea?

Code: Select all

       ...
                cSQL := "CREATE TABLE #TEMP ( [FName] CHAR(50) ); "+;
                            "INSERT INTO #TEMP VALUES ('Antonio Linares'); "

                IF AdsCreateSQLStatement( 'temp', ADS_CDX, hADSSERVER )

                   IF ADSExecuteSQLDirect( cSQL )
                      xBrowse( 'temp', 'ADS v'+AdsVersion()  )
                   ELSE

                      MsgAlert(cSQL,'Unable to Execute SQL Statement - SQL Temp Alias')
                   END

                ELSE

                   MsgStop('Unable to Create SQL Statement', 'SQL Temp Alias')
                END
   ...
 

Regards

 cSQL := "CREATE TABLE #TEMP ( [FName] CHAR(50) ); "+;
         "INSERT INTO #TEMP VALUES ('Antonio Linares'); "+;
         "SELECT * from #TEMP"