Recent content by stevenba

Hi all. New to flash. I just can't seem to get a foothold into flash regarding creating an input form, and then posting the params to a server side script, such as php to process it. I'm on Flash 8, but the documentation does not seem that good in that it assumes a few things. Any pointers...

Hi, I have an app that runs on MS Access or SQL Server. However, due to the complexity of the schema, DTS and the upsizing wizard did not correctly upsize the data. I had to manually created create triggers, etc. My problem is that i would like to automate a fool-proof way of upsizing the...

Thanks for that. It works great for the table in isolation. But with other tables 'hanging off it' ie having fk relate to the contacts pk, when deleting, i get the error '[microsoft][odbc sql server driver][sql server]Maximum stored procedure,function, trigger, or view nesting level exceeded...

I beleive that I have fixed it. I have created a recursive procedure which drills down through the heirarchy deleting children by calling itself. This is initially triggered by an on delete trigger set for the contacts table. However, to get this to work, the options for recursive triggers has...

Apl;ogoes - some of the delimiters did not seem to appear. The corrected version is below. The data in CSV format is below: ************* start of data ************************ B02D292E-B5DE-4C92-A45E-0354A85401FB,"sbaker","Borg, Simon",NULL...

The data in CSV format is below: ************* start of data ************************ B02D292E-B5DE-4C92-A45E-0354A85401FB,"sbaker","Borg, Simon",NULL B07381A7-C103-4178-AF40-089793EBB169,"sbaker","Baker, Gary",NULL DA8DF60A-EA57-4463-98A7-1AF2A4A351C7,"sbaker",Co-Op garage,NULL...

The DDL to create the sample table is below: ************* start of create table ************************ CREATE TABLE [Contacts_Sample_Data] ( [ContactID] [uniqueidentifier] NOT NULL , [CreatorName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [DisplayName] [nvarchar] (128)...

Thanks for the reply. I can give you sample data. How do you want it? I assume a text dump of table def and data would be OK? I'm not sure how to dump the data in SQL Server but will take a look. Thanx, Steve Baker

Have used DTS to import just the one table with no ref integrity or triggers. Created PK on ContactID, and then used this DDL SQL to attempt the self join (ParentID -> ContactID). ALTER TABLE [dbo].[Contacts] ADD CONSTRAINT [Contacts_FK00] FOREIGN KEY ( [ParentID] ) REFERENCES...

Thanks for the reply. I'm absolutely sure there is no cyclical ref. This is enforced in the application, and when I delete the exactly same data in MS Access, this happens with no problems. I will look to rewriting the ddl created when MS Access upsized the schema.

Have set recursive triggers to on , but when i try a cascade delete, i get an error: [microsoft][odbc sql server driver][sql server]Maximum stored procedure,function, trigger, or view nesting level exceeded (limit 32). Surely it can't be that difficult to do? Anyway, i will be away from my...

I have tried it both on and off. I would have assumed it work ok with it on, but not. btw, used exec db_option 'mydbname', 'recursive triggers', called from query analyser. .. to (un)set and check this. Is there anything i'm missing like resarting server or anything. thanks for the prompt...

Hi, ************************************************** ***** * Main problem - cascade deletion of self joins and also child tables. **** ************************************************** ***** I have a schema with a self join in the main table as well as other child tables. Its for a CRM with...

i've fixed it. The clientDataset is attached to a provider which is attached to a adodataset. The porblem was caused by only defining the fields in the fielddef property of the clientdataset - was resolved when the fields were defined in the adodataset as well.

Hi, I'm developing an app in delphi 7, using tclientDatasets. Since upgrading to D7 from D6, i've had nothing but problems, with issues which were supposed to be fixed in sp 7.1. The latest one is when i call the RefreshRecord on a TClientDataset, i get 'unable to find record no key...