Recent content by rmtiptoes

Tried that but this db has an application sitting on top of which does not allow the structure to be revised. So I have to maintain the integrity of the fields and tables Homer: But every time I learn something new, it pushes out something old! Remember that time I took a home wine-making...

So glad you responded! Good question. Not sure how to handle this will have to research more. Any suggestions? "2)SET @SHOPPERSON=(SELECT LAST_NUM FROM SEQ_NUMBER WHERE COLUMN_NAME = 'shop_person') this will probabaly always get the same row 3) what happens when 2 users hit this at the same...

Hi All, I am trying to create a trigger that auto-increments a PK field from another sequence table. Since I cannot change the structure of the existing table, I need to pull and increment the field and update the record for insert as a char type field. When I insert the record in the...

thank you very much. that actually worked!! Homer: But every time I learn something new, it pushes out something old! Remember that time I took a home wine-making course and forgot how to drive? Marge Simpson: That's because you were drunk! Homer: And how.

I have recreated a new report from an existing report but accidentlally saved the .rol file. Now i cannot see the old query (.rol) file. I have the orinigal from the install but cannot link the originl file (.rod) to the original .rol. Is there a way to do this? I have renamed both files but...

Thank you both!!! Been working on this all NITE!!! I actually tried all of those but in the wrong combinations. A million thanks!!! Homer: But every time I learn something new, it pushes out something old! Remember that time I took a home wine-making course and forgot how to drive? Marge...

I am trying to create a dynamic sql process based upon the following update code: UPDATE WORKORDER SET STATUS = 'COMP' WHERE REPORTDATE >= TO_DATE('08/01/2006','mm/dd/yyyy') AND STATUS = 'INPRG' AND ACTFINISH IS NOT NULL AND WONUM NOT LIKE '7%' Which works fine. The dynamic sql code is as...

Never mind. I found a duplicate Homer: But every time I learn something new, it pushes out something old! Remember that time I took a home wine-making course and forgot how to drive? Marge Simpson: That's because you were drunk! Homer: And how.

I continue to get the the following error when importing a CVS file into SqlServer2000: "cannot insert duplicate key row in object 'table1" with unique index 'table1_ndx'. I have looked at the records and there are no duplicates. No matter how many rows I test, I continue to get this error...

THAT WAS IT!!!!! THANKS A MILLION!!!!! Homer: But every time I learn something new, it pushes out something old! Remember that time I took a home wine-making course and forgot how to drive? Marge Simpson: That's because you were drunk! Homer: And how.

Yes. That one! Homer: But every time I learn something new, it pushes out something old! Remember that time I took a home wine-making course and forgot how to drive? Marge Simpson: That's because you were drunk! Homer: And how.

I have a form that displays records based on a form filter and combo box. The problem is that no matter what I select, the last null row from the table keeps printing and I cannot figure out why or how to hide it and do not know why it is printing. Can anyone help? Homer: But every time I...

Does anyone have any idea hot to insert row totals for a crosstab query? My form/report is grouped at two levels and using the =Sum(NZ([2005])) returns the sum at the highest grouping. Not at the lowest one. Homer: But every time I learn something new, it pushes out something old! Remember...

Hi! Are you still there? This actually came close. I have been adjusting it. The strSecLvl kept changing to maintenance at the same point in the code, then I looked more closely and find that a this point strSecLvl = Choose(x, "Maintenance", "Receiving", _...

Thank you for your research!!! And I see. quote: "On your return post (when I asked you to perform a search) you didn't say whether or not you found strSecLvl. This should've been revealing as you stepped thru all locations found. If you havn't done it, you should do so & log all...