Miyako,
One of the problems is that 'Get Last Table Number’ doesn’t acknowledge the new
temporary table at all, but the Util_GetTableNum function does.
For example, after I create the temporary table, Util_GetTableNum returns table
number 51. But then when 'Is Table Number Valid’ fails in my code, I log using
the following method and 'Last Table Number' gives me 48.
See output below (I trimmed it for obvious reasons). It reports the temporary
table as a missing table (And I’m not sure why I have 5 missing since I’m using
CREATE TABLE IF NOT EXISTS each time).
Also, this only happens when compiled, client/server.
ARRAY TEXT(asTables;Get last table number)
If (Get last table number>0)
For ($vlTables;Size of array(asTables);1;-1)
If (Is table number valid($vlTables))
SEND PACKET(MyLogDoc;Char(13)+String($vlTables;"00 ")+Table name($vlTables))
Else
SEND PACKET(MyLogDoc;Char(13)+String($vlTables)+" *Deleted*")
End if
End for
End if
ARRAY TEXT($arrMissingTables;0)
GET MISSING TABLE NAMES($arrMissingTables)
$SizeArray:=Size of array($arrMissingTables)
If ($SizeArray#0)
For ($i;1;$SizeArray)
If (Find in array(asTables;$arrMissingTables{$i})=-1)
SEND PACKET(MyLogDoc;Char(13)+$arrMissingTables{$i}+" *Missing*")
End if
End for
End if
//**********Output*********//
48 Table48
…
…
02 Table2
01 Table1
TempTable_4dt *Missing*
TempTable_4dt *Missing*
TempTable_4dt *Missing*
TempTable_4dt *Missing*
TempTable_4dt *Missing*
Regards,
Mark
> On Oct 10, 2017, at 12:12 PM, Keisuke Miyako via 4D_Tech
> <[email protected] <mailto:[email protected]>> wrote:
>
> why not simply use Get last table number?
>
> and you don't really need to use SQL to get a table pointer from name, just
> do something like...
>
> C_POINTER($p)
> $name:="Table_1"
> $formula:="<!--#4DEVAL $1->:=->["+$name+"]-->"
> PROCESS 4D TAGS($formula;$formula;->$p)
**********************************************************************
4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com/faqnug.html
Archive: http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:[email protected]
**********************************************************************
