|******************************************************************************
|* tssoc9999 0 VRC B61U a stnd
|*
|* demo
|* 07-06-07 [17:44]
|******************************************************************************
|* Script Type: 123
|******************************************************************************

|****************************** DECLARATION SECTION ***************************
declaration:

table ttitrp002,ttssoc210,ttcmcs060

long sql
|****************************** PROGRAM SECTION ***************************
|****************************** ZOOM FROM SECTION ***************************
|****************************** FORM SECTION ***************************
|****************************** CHOICE SECTION ***************************
|****************************** FIELD SECTION ***************************
|****************************** MAIN TABLE SECTION ***************************
|****************************** FUNCTION SECTION ***************************
before.program:

test()





functions:



function long test()

{

sql =sql.parse ("delete from tssoc210,titrp002 where tssoc210.orno = :titrp002.serr and tssoc210.acln >10")


return (sql)

}

Yo Mohamed,

What makes you think this is the way to program in Baan 3/4GL?? I advice you to take some basic Baan tools & development training before experimenting around, or at least read some of the Wiki pages on this board.

Good luck!

Regards,
Eli Nager

please mr help me npw at this proplem i am afrish man at BAAn and i want to helpe me to now what is proplem

I found none of the delete threads helpful at all - so I deleted them. I can understand your where you are coming from, but none of it helps hossam mohamed. It would be nice if everyone's English was perfect, but that is not the case. Nor can we expect everyone to have your alls level of expertise.

Having said that hossam mohamed - the best thing you can do is start reading the wiki attached to the board to learn the basics of what you are trying to code. I think that will be best - plus a training class would certainly help. So please read the Wiki and all of the programmers manual. Once having that done, start searching the board for the topics of interest and read those threads.

Mark,

I agree, it was a naughty post of mine, just couldn't resist. I did in fact give Mohamed the same advice that you just gave him, yet he obviously did not feel it was satisfying, and requested/demanded concrete help.

I do not feel any superior on people who's English is not that perfect, neither do I feel that way towards people with a lesser lever of Baan-knowledge/experience. It was the approach which made me write that post.

But again, you are probably right for deleting that previous post of mine.


Sincerely,
Eli Nager

Hi Hossam,

The following link has the a good info about SQL programming:
http://www.baanboard.com/programmers_manual_baanerp_help_functions_database_handling_baan_sql

If you are looking for Dynamic SQL you can check this link:
http://www.baanboard.com/programmers_manual_baanerp_help_functions_database_handling_dynamic_sql

I hope it helps,

- George