Search results for query: *

Im having a problem and need help. This is in relation to database. I have VB6.0 and Access 2000. When I put controls on a form and then the DATA CONTROL and then I click on the ellipsis next to the DatabaseName property of the data control and select the file I want to use. When I set the...

We mistakenly created a new key as primary key even though we had a perfect candidate key for that. Now we want to delete that and make the candidate which is already a field on our table the primary key. Problem we did not want to delete that until is visible via erd. My question is, can we...

hi rcurva! thanks for responding to my thread. this sql statement is a cartesian join and is hanging up. what i did was change my original sql and change sum(t.id) to count(t.id) and it worked. thanks again

I decided to resend this thread because I was struggling making my point clear. I will like to see my output formatted like this: t.lname #Unsigned t.id t.fname t.spec t.docid Jim 91 13 eddy 15 30 This is what I have: select distinct t.lname...

Come on guys I am sure someone in here can help me. I just want totals like this: ename dept total king 10 5 james 30 10 No sub totals and no grand totals.

I am trying to get a total count of certain employees. I am using select colum1..columnN, count(*) from emp where empno = P_empno group by rollup(colum1,columnN) Say for instance there are 30 employees in dept 10, I want it like: ename dept total king 10 3 Right now I am getting...

any time I run my report, i use date ranges. eg select * from emp where begin_date between to_date('01/01/1986,'mm/dd/yyyy') and to_date('12/30/1999,'mm/dd/yyyy'). Now, how can I set the begin_date to display at the top of the form like this: December, 1986 and then report follows? thanks!

Wow, you took your precious time to do this for me!! Thank you very much ghilpert!!!

I am trying to perform an action a forms field after an insert or update, depending on the situation. I have this code that is not working. Can anyone please look into this for me? I assumed it to be a pre-insert/pre-update trigger. My other problem with this code is understanding how to...

this is great! sem, take some stars on my behalf! zik

thanks sem! I am pasting of a portion of your thread that I am particularly interested in: We also change some registry settings e.g. add FORMSxx_PATH, REPORTSxx_PATH and some others. I have two questions: Where do I find FORMSxx_PATH, REPORTSxx_PATH? What part of the registry do you make...

I truly, truly appreciate this. zik

thank you ghilpert. yes, i want more detail. i know that i have generated the binary files for reports and forms. i was told to use project builder and file packager. what is file packager anyway. please assume that i know nothing about deploying forms and reports runtime. any help from will as...

i have answered my own question. is this forms/reports forum?

Has anyone been involved in deploying dev2000 (forms, reports) application to windows (not web). If yes, PLEASE, PLEASE tell me the steps, if possible. I hear names like checkmap, oinus.msb, PRD etc. They are so novel to me that I don't even know where to start. I have developed the forms and...

Sem, thanks! much appreciated. zik

to run forms and reports, do you have to have a server for the forms and reports to run on. My company is thinking about getting forms and reports but we need to know if they need server to run on. Please let me know urgently. thanks, zik

to run forms and reports, do you have to have a server for the forms and reports to run on. My company is thinking about getting forms and reports but we need to know if they need server to run on. Please let me know urgently. thanks, zik

Sorry you had to waste your time on this sem. I realized what the problem was but could not get here on time to advise of it. Thanks anyway for responding very quickly. zik

Can someone please tell me why this code is not working? CURSOR c_1 IS SELECT call, call2, call3, call4 FROM mytab WHERE ((caller = 'I') and (call_in = ' ' OR call_in is null) and (call_referrer = 'A' OR call_referrer = 'B' or...