try escaping them. and use macro sc_exec_sql

Scriptcase 9 General
#1

[SIZE=14px]Parse error: syntax error, unexpected ‘Timestamp’ (T_STRING) in C:\Program Files (x86)\NetMake\v81\wwwroot[/SIZE][SIZE=14px]scriptcase[/SIZE][SIZE=14px]\app\Pong8[/SIZE][SIZE=14px]\blank\ind[/SIZE][SIZE=14px]ex.php on line 1079[/SIZE]

please help how to fix

sc_exec_sql("CREATE TABLE StepOneSection as SELECT public.pong8.\"Timestamp\", public.pong8.\"Last\", public.pong8.\"Trade Price\", public.pong8.\"Trade Volume\", public.pong8.\"Best Bid\", public.pong8.\"Bid Size\", public.pong8.\"Best Ask\", public.pong8.\"Ask Size\", public.pong8.\"Turnover\" FROM Public.pong8 ") ;
#2

Try this:


$sql = 'CREATE TABLE StepOneSection as SELECT public.pong8."Timestamp", public.pong8."Last", public.pong8."Trade Price", public.pong8."Trade Volume", public.pong8."Best Bid", public.pong8."Bid Size", public.pong8."Best Ask", public.pong8."Ask Size", public.pong8."Turnover" FROM Public.pong8';
sc_exec_sql($sql);
#3

Hi Mamede

thank you

it works