suppose i want to execute an update query like

update table set field='some value' where somefield='xyz'

how can i execute this query using llblgenpro

i do not want to create and use stored procedure ?

i m using 3.1 version and selfservicing

thanks in advance and have a nice day !!!

Look for the Modify an Entity - Option 1 in this documentation link.

daelmo wrote:

Look for the Modify an Entity - Option 1 in this documentation link.

this is not the answer i want.

i want to execute the query for multiple records like update, insert and delete. i do not want to fetch one by one record and do the update, insert and delete process

in short i want to know that if any alternate exist for sqlcommand in llblgen pro if yes then what is it ? and if no then what is the other way to achieve this goal ?

thanks in advance and have a nice day

We can execlude Inserts from your question, right?

In the link David posted, look for Option 3: UpdateEntitiesDirectly Similarly there is DeleteEntitiesDirectly.

These work as you want, directly on the database without fetching any records beforehand..