Recent content by kprogrammer

It is a table sch-s lock. We are using enterprise manager to identify the locks. The queries we have been testing are just simple select statments, but of our selects come out of stored procedures. So these locks are not a problem that we should be worrying about? What casues them? Kirk

Query maker is my shortcut name for SQL Query Analyzer (sorry for not being specific) This happens with any querry, even basic ones such as: Select * from tbltimesheet with (nolock) where cl_code='xyz' Thanks Kirk

We are running SQL Server 2000 on a windows 200 platform. Recently we started having a problem with our nolock hints, even directly out of query maker. The associated select queries are causing table level locks. The table we wroking against has approximatly 7 million rows. Has anyone had this...

We recently switched to SQL SERVER 2000, Standard edition, on a Windows 2003 platform. The memory is 4 g, set to 70% read and 20% write. 100 users. We are experiencing widly varing response times. Does SQL Server handle 1 request at a time? Do the number of reads shown in the profiler indicated...

Thanks for the info. I'll look into this. Another contact also told me to look into limits on the length of SQL statements. Kirk

I am using SQL passthrough. The called process adds the connection. The cleanstring method does just what it implies, cleans up the string for passing to SQL and then adds the required enclosing quotes. c_erdtl and c_memtxt are the strings going to the text columns. They are build by a series...

I am trying to insert a new row into an SQL Server 2000 table from VFP 8.0 The table includes two text data type columns. When I have small strings of data, the insert will populate the text columns, but when I try to insert larger character strings (80,000 characters), no data is stored in the...

I would like to fix the problem in the common dialog, but I suspect it is a problem with the memory being allocated for the array to store the list of selected files. There just isn't enough of it, and when it is exceeded the entire selected list is dropped. I don't know how I can fix this. Kirk

The number of files selected is between 100 and 150, and I know it is not exceeding the VFP array limits. I'm looking at adapting the treeview control for my app now. I'm not sure if it will work since I need to get the data on the selected files out of it. I'm need to find a solution. Thanks...

This is the code I used to set up the common dialog (cusCommonDialog). It works great untill the list of files gets long. Thats when the entire list gets dropped! The returned array is empty and the associated filecount property is 0. Kirk

I am working in VFP 8 and using the common dialog to select files. The control works fine until the number of files, in conjunction with the size of their names increases. When this happens, the control returns no files in the selection array. I believe I am exceeding the controls allocated...

As Tamar says, I can't use the "DO FORM" command since these forms are instantiated from classes. I like the hide form idea and will try this since only the calling object will need to know the objects ids in the called form. (No hard coded ids referring back to the calling object in the called...

We are working class forms (classes that are subclassed from the base class "form") and I need to return values to from them to calling programs/classes. We are working in VFP8. I know that I can use public variables, cursors or an object reference passed as a parameter (then update the...

Once the "set century on" command is issued, the message box no longer displays properly. A subsequent "set century off" command does not correct the problem. I agree that it is very weird. I have to think that there is something else somewhere that is causing this because it makes no sense to...

I was able to track down where the messagebox's erratic behavior begins in our application. However it makes no sense to me. It is right after a setting in out class load method. We have private data sesions so the following settings are applied in our base class: SET REFRESH TO 0,0 SET...