Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by cadoltt
-
proc doesn't work when called from trigger
Hi Taupirho, Thank you for taking part in it. I was also thinking about a composite ID, but there two things which make it hard. First, the physicians want the treatment number to be a simple sequence reflecting treatments natural order. Second, dates might be incomplete (only the year is...- cadoltt
- Post #7
- Forum: Oracle: All versions
-
proc doesn't work when called from trigger
Jimirvine, SantaMufasa, Yeah, this really turned out to be a mutating table error - at least now I know where to look at. Thank you very much for the tip! Alex- cadoltt
- Post #5
- Forum: Oracle: All versions
-
proc doesn't work when called from trigger
Hello everybody, I am not experienced in writing table triggers and I'm stuck with something I don't really understand. I have a table which keeps track of treatments patients receive. It has a composite primary key pt_id + treatment_number. The treatments should be numbered sequentially...- cadoltt
- Thread
- Replies: 6
- Forum: Oracle: All versions
-
Excel from Access:"Object variable or With block variable not set" err
Roy-Vidar, Skip, Thank you for clarifying things. And what I really love is to simplify code :-) Alex- cadoltt
- Post #6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel from Access:"Object variable or With block variable not set" err
Skip, It works now. 'i_Ex_row' was just a typo when I was simplifying the code for the post. Thanks a lot! Alex- cadoltt
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel from Access:"Object variable or With block variable not set" err
Hello everybody, I am observing a strange behavior of my Access (2003) VBA code. I have a procedure (in a form) to copy an Access table into an Excel file. The sub opens an excel application and a recordset, then loops through the recordset rows and transfers the values into excel cells. Here...- cadoltt
- Thread
- Replies: 5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Fail to run JSP from ColdFusion
Thank you, TruthInSatire, Not a good message for me, but I don't kill messengers :-) Guys, Is it too naive to ask if there is a way to put together CF with some of free JSP servers, such as Tomcat or anything else? Thanks Alex -
Fail to run JSP from ColdFusion
Hello All, I have CF MX 7 Standard installed on my desktop PC (Windows XP professional, IIS 5.1) for development purposes. From what I read about CF MX 7, I get that it can run JSP. To test it I created a simple JSP page (hello.jsp): <HTML> <head> <title>Test</title> </head> <body>... -
2 users attempt to create accounts with the same ID: how to prevent
KenCunningham, You are quite right. SantaMufasa, The star is awarded. I wish it was the Silver Star or Medal of Honor :-) Thanks again! Alex- cadoltt
- Post #9
- Forum: Oracle: All versions
-
2 users attempt to create accounts with the same ID: how to prevent
Guys, First of all let me apologize. In my previous post where I said 'The way suggested by MikeyJudd...' I meant SantaMufasa - I just copied the name from a wrong spot. So my apologies to both SantaMufasa and MikeyJudd :-) SantaMufasa, Your first suggestion was already good enough and this...- cadoltt
- Post #7
- Forum: Oracle: All versions
-
2 users attempt to create accounts with the same ID: how to prevent
Thank you for answering, guys. Everything is a simplified in my post, including the table structure, let's suppose it has just two fields (vc_user_nickname and vc_user_pw) and as I mentioned there is UNIQUE constraint on the vc_user_nickname field. Of course this constraint will not allow the...- cadoltt
- Post #5
- Forum: Oracle: All versions
-
2 users attempt to create accounts with the same ID: how to prevent
Hello everybody, This situation has to have a standard solution but I couldn't find it so far. Imagine multimple users create their accounts and there is a table to store the personal data one of the fields of which is to keep the user nickname. Nicknames have to be unique. Here is a...- cadoltt
- Thread
- Replies: 9
- Forum: Oracle: All versions
-
Requery doesn't work in form
Hi TheAceMan1! 'How To Get Good Answers To Your Questions' - is a good compilation of what's needed to make people answer questions, I always try my best to follow the advices. And thank you for info in the quote. Alex- cadoltt
- Post #7
- Forum: Microsoft: Access Forms
-
Requery doesn't work in form
Ed, Honesly, I started playing with Recordsource before your post, I did this way: Call CreateQuery(sSQL, "qry_1") Me.Recordsource=qry_1 and it statrted working. However I took your suggestion because it simplifies things. Now, when you warned me about changing queries on the fly I'll...- cadoltt
- Post #5
- Forum: Microsoft: Access Forms
-
Requery doesn't work in form
Ed, It works. Surprisingly to me it works even if I remove Me.Requery. Thank Heaven there are always people who know more than you... Thanks again, Alex- cadoltt
- Post #3
- Forum: Microsoft: Access Forms
