Hi, I have added a de ('deMy') to a form, for now at least I am not using ca's but in the load of the form I can do e.g.
local nHndl nHndl = thisform.deMy.DataSource cSQL = [select * from foo] nOK = SQLEXEC(nHndl, cSQL, 'curFoo') Q1. it seems I (the_programmer) have to remember that the de is called 'deMy' - the name/ object reference isn't available anywhere? Q2. I would rather put that logic in a busObj - but how should the busObj get the connection handle? - at present I use: thisform.NewObject('oData', 'myData','myMain.prg') 'myData' in myMain.prg can be expected to know about _screen.activeform but not (surely) about deMy, I suppose I could pass parameters to myData.init() but Help! seems to have errors/ mismatch with Intellisense: Help! > Object.NEWOBJECT(cObjectName, cClassName [, cModule [, cInApplication [, eParameter1, eParameter2, ...]]]) > cInApplication > Specifies the Visual FoxPro application (.exe or .app) containing the .vcx visual class library you specify with cClassLibName. You must include an extension for the application. CInApplication is ignored if cModule is omitted... I assumeHelp! means cModule not cClassLibName? Intellisense: > Object.NEWOBJECT(cName, cClass, [,cModule], [,cInApplication],[cOLEClass], [, aInit1...]) all (oopy) suggestions welcome (including "use ca's" I guess <g>). Andrew Davies MBCS CITP - AndyD 8-)# ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. Please contact [EMAIL PROTECTED] with any queries. ********************************************************************** _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.