Recent content by aharrisreid

jrbarnett, thanks for the reply. >They will have been delete automatically by SQL server when the connection gets closed. If you create it with Query Analyser, you can do a select * from tablename to see the contents. Maybe I wasn't clear enough. When I said I want to view the tables I meant...

jrbarnett, thanks for the reply. >Temporary tables go into the tempdb database. Can I view a listing of these tables? I've looked in the table-tree for the tempdb database and I cannot see the temporary tables. Regards, Alan

In the T-SQL window I have created some temporary tables using the syntax SELECT * INTO #MyTempTable FROM MyTable. Where can I find what temporary tables are currently available (I don't want to delete them yet using DROP TABLE ...)? I cannot find them in any enterprise mgr. table listing...

Hi donutman, thanks for the reply. >Create another table for the image data (or whatever) and >populate it with just a >CODE >SELECT DISTINCT PK FROM YourTable > Then update that table adding the image data by doing >an inner join between the two tables. The update will >only be done...

Hi donutman, thanks for the reply. >I don't think you can get SQL Server to ever accept a >duplicate PK as Access just turns off the constraint. I am using SQL server, and under 'normal' circumstances you would be correct - if the table was setup correctly a duplicated PK would not be...

I have a table containing hundreds of duplicate records (even the primary key is duplicated!) which I wish to remove. The first thing that came to mind was SELECT DISTINCT * FROM MyTable, but MyTable contains a text field, hence I get the error "The text, ntext or image data type cannot be...

Hi Olaf, thanks for the reply. >>Quote (aharrisreid): >>I would have expected PEM sheet values to become the new >>original value! >No, that would be the case in a subclass of that class >when you don't change anything from that moment. I have since discovered that as long as the subclass is...

Mike, thanks for the reply. >PUBLIC ARRAY myProps[1] >AMEMBERS(myProps,this.Parent,1,'C') Tried that, but unfortunately the resulting array includes properties that have have been changed in the PEM sheet of a subclass, but not altered since (eg. during running of a program). I would have...

Craig, thanks for the reply. >I do it immediately via a stored procedure and call that > procedure fron the default value for the primary key field If you were using VFP as a front-end to SQL (using remote views), would you use a VFP stored procedure (in the .dbc), or a back-end procedure...

I have encountered a problem with my application framework and would appreciate input from other developers before deciding which way to go. When allocating a unique identifier (or primary key, usually an integer value) to each new record, is it better to allocate a) immediately the record is...

Hi Marcia, >You may want to create an assign method on that property >and write some code there. Thanks, I didn't think of that option. Regards, Alan

mgagnon, thanks for the reply... >Take a look at GETPEM() I tried GETPEM(), but this is returning the value of the property when the function is called, not the value as set in the PEM sheet. Regards, Alan

Once a form is showing, I need to ascertain if the value of a property has changed from the value originally set in the PEM sheet. I have tried using PEMSTATUS(object,property,0), but this returns .T. even if the value was changed manually from the default value in the PEM sheet at design-time...

mgagnon, Thanks for the reply - I'll look into the articles you suggested and take it from there. Regards, Alan

My client is running an insurance sales website which invites users to complete a form which is then submitted, a premium calculated, and (hopefully) a sale made via a credit-card transaction. Up to now the premium calculation has been very straightforward (ie. a flat-rate monthly or annual...