Hi all,

I have a tempxxx table that contains hcode field as numeric for example 55555

but I would like to get the infos from SQL server tables hierachy and h_node

tempxxx table :( normal dbf or cursor )
hcode field

55555
66666
....


h_node table in SQL server :
hcode field

55555
66666
77777
88888
99999

hierarchy table in SQl server :
hcode field

55555
66666
77777
88888
11111
99999
00000
....
....
....

my results should get only the number 55555 & 66666 and denied the rest into
my temptodelete table after passing sqlexec command.

here is mycodes :

SELECT tempxxx

IF RECCOUNT() > 0

GO top

DO WHILE !EOF()

lcSelectSQL ="SELECT DISTINCT hier.account_code as account " + ;
"FROM h_node hnode, hierarchy hier " + ;
"WHERE hier.hcode = hnode.hcode and hier.hcode = '" + tempxxx.hcode + "'"

lnExec = SQLEXEC(lnconnect,lcSelectSql,'temptodelete')

SKIP

ENDDO

ENDIF

=sqldisconnect(lnconnect)

SELECT temptodelete
BROWSE

Any help in correcting my codes or new coding would be appreciated ?
TIA