I have a new form bound to a table object. I have populated the field values in few of the controls. I have used profiler to find out the sequence of operation executed. For some reason, I do not see the INSERT INTO [BASE TABLE] statement.

What am i missing in the the design?

Please help

Thanks

I'd suggest you would benefit from some developer training. Where are you located so that we can advise on your nearest point of training. Right now you appear to be running before you can walk.

A form can only be bound to a grid (to perform an insert/update) [whcih isn't strictly true, but is in the sense you are describing]. Without knowing more about the context of what you are doing it's virtually impossible to help. Otherwise, you are simply dragging us into a Monty Python sketch (google it) "Where is London?", In England, Where's that?, In the UK, Where's that? Europe. Which is where? Upper Hemisphere? Where? Earth. In the Solar System, in the Galaxy. Geddit?

Thanks for your suggestion. For your information, I am in development for many years, but not in Saleslogix. I can do some minor modification in Saleslogix as part of maintenance. I got a new development item to create a form similar to existing one and point to different table object.  I have reviewed the existing ones to the extent possible and started this new development. I have compared the Profiler logs between the 2 and found out that the new form doesn't fire the INSERT statement. I can also write explicit INSERT statement and complete the operation. But I just want to understand how the existing form handles.  I do not see anywhere in the code INSERT statement.

Thanks for your assistance.

Unfortunately, you merely confirm what I've said. You could be a developer in C#/F# or gString for a hundred years - makes no odds whatsoever. I'm not trying to disparage your experience - but, evidently, your statements show that you don't understand SLX development - which is precisely what training is all about

The form will not fire the insert if it's not launched from a grid that is linked/bound to the data views you are trying to launch. You should have no need to write explicit inserts - if the grid + forms are wired up correctly then it will do it all automatically for you - with no code to write.

Thanks! That's exactly what I thought.. The form should have fired the INSERT statement. I will review the form again..

Any suggestions greatlyappreciated!

Very quickly !

1) Assume you have TableA that contains an item you want to edit

2) Create a new form (account, contact etc)

3) Add a new grid object to the form. Set the BindID of the grid to the entityID e.g. AccountID, ContactID - this ensures that this changes as you move record (and, therefore, refreshes for data found etc).

4) In the SQL property - click the elipse and select the table you wish to insert/edit to. Select the link ID (that's common to both) in the field below. Save this form.

4) Create a new Data form - based on the table you wish to Edit

5) Add to this form the items you wish to edit/create. Bind the objects (the Text property) to the items available in the list. Save the form.

6) On the grid (saved in 3) modify the Edit View to be the form saved in (5)

Done ! Now, the grid will show the rows, right click - Add will add a new item, Edit, will edit existing.

Thanks!

Thanks for all your help. I have resolved the existing issue. The issue here is ..datagrid is based on a query and therefore, the bindID is missing in that query. OnceI fixed that, I was able to save and view the data

Thanks again!

Good news ! Glad it helped resolve your issue.