Hi all,
I have a couple of spatialware questions that I could use some help on. I am running spatialware on SQl Server, and using a large MapBasic program to
1. When I am save a spatial table on spatialware, it seems to take a very long time. When we look at what was happening in SQl, it was doing a select statement for every record in the db, then an update on the 40 that had been edited. Is this normal and is there a strategy to get around this - or is this something in my code that has caused MI to trigger this activity?
I used to have a function that updated all rows to fix up program maintained data, but have changed this to only change where the data is different,and can't find any other spot where it would change all rows. The performance logs in SQL show that there is only a few rows that are updated - or is this some performance Now it selects out rows where the data is different and updates this selection. Non-spatial tables seem to be much quicker, and if I delete a record in MapInfo directly, the save is relatively quick. All I am after is some indication if this is normal behaviour or not.
2. If I try to do an automatic ApplyUpdates on a commit statement, I get a failure to save. I get the same if I then try to do an automatic update from the conflicts resolution dialog. If I use interactive clause, I don't get any conflicts. Is there a known problem with the automatic save in version 7.0?
3. I ended up getting an answer for how to edit a View of two base tables in SQLServer from MapInfo. You use a trigger on the view and put an instead of clause for the delete, update and insert options, and apply the changes to the base table. It is a useful trick as you can store your data in one master table, and use a join between tables to define datasets for different users (eg. a district table and customers table). You can then filter the rows and columns to give you a subset of the master table for each user based on data from the joined table. I couldn't edit this data until I was shown this 'instead of' trick. If anyone is interested in the technique, I can give code examples.
r
-- ________________________________________________
Robert Crossley
Agtrix P/L 9 Short St PO Box 63 New Brighton 2483 Far Southern Queensland AUSTRALIA
153.549004 E 28.517344 S
P: 02 6680 1309 F: New Connection M: 0419 718 642 E: [EMAIL PROTECTED] W: www.agtrix.com W: www.wotzhere.com
--------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 13953
