• How to implement Sleep logic not using sleep() need customized

    Hi Experts, I need to implement a sleep logic in a loop i need to check for SELECT/INSERT stm if it s locked by other user i will go to sleep mode then back to earlier savepoint position eg savepoint x; INSERT/SELECT i need to check for 10 times each time sleep is for 1 sec i applied counter i...

    Inprise610 pointsBadges:
  • Using WildCards in IIF Statement

    Hi, I have a query that uses a field on a form to filter what information gets displayed. This is simple I know but what I need it to do is display all records if I don't enter anything in the field on the form. I tried putting the following IIF statement in the Criteria:...

    RoadDust390 pointsBadges:
  • Clustered and Non-clustered Index

    Hi, I have one table having more than 3 millions rows with following columns: [SITE_ID] [USER_NAME]

    Plugsharma40 pointsBadges:
  • ALTER INDEX statement

    'ALTER INDEX ' || C_Indices.INDEX_NAME ||' REBUILD '; 'ALTER INDEX ' || C_Indices.INDEX_NAME || ' REBUILD ONLINE COMPUTE STATISTICS'; In my stored procedure , i am reconstructing or you can say re-building the tables and table name is the input parameter to the procedure. In middle of the code , i...

    Shaksing5 pointsBadges:
  • PL/SQL: How to handle OUT Parameter during INSERT

    HI Experts, I have a OUT parameter in my procedure(whihc performs INSERT data into a table),how to handle this OUT parameter (primary key of table) -- Will Insert statement inside the PL/SQL block should include this parameter or we should use SELECT stm after Insert to add this attribute ,i am...

    Inprise610 pointsBadges:
  • Creating form with combo box to enter data

    I trying to create a form in an inventory database that uses a combo box to select size and depending on the size, use a text box with the quantity and have it populate the correct size field. If I am way off base, please suggest alternative.

    Cecee5 pointsBadges:
  • Passing Parameters in Access into Vb6.0

    How to pass Parameters in MS Access into Vb 6.0 and get the results through ado recordset

    Bijaybehera2915 pointsBadges:
  • Multiple instances with SQL Server

    Is it adviceable to put SQL 2000 and 2005 in one single CLuster by putting them in different instances?

    IMR5 pointsBadges:
  • Microsoft Access database too large – Can I divide my Access file?

    Im new to access and have been given a task to compile a data base, which i have very nearly completed, Im in the military and using a PC networked into a military system. However i found out whilst compiling the Database the system has many limitations, the Document has got to 1.99 GB now and will...

    Ukmale5 pointsBadges:
  • Loading signature into a PictureBox control

    I'm trying to load a signature into a pictureBox but its giving the "Parameter not valid" error message when it tries to convert into bitmap from the MemoryStream store. Refer code below. code: public Bitmap getSignature() { MemoryStream ms1 = new MemoryStream(Signature); Bitmap signature = new...

    Twlp123165 pointsBadges:
  • Writing vertical data to a flat (unfortunately!) table

    I have an application that I need to update (written by someone else) that requires that I take data from a nice, vertical table and write them into a pre-exisiting flat table. Column 1 of the vertical table is the PK for the flat table, while there are up to 35 entries that must be written into...

    Kingle15 pointsBadges:
  • SQL script output to a file

    I am running ad hoc SQL scripts in iSeries Navigator (V5R4) and need to direct the output to a text file. Is there a way to do this? TIA... Steve B

    SBatSI415 pointsBadges:
  • Inserting rows and multiple rows in SQL Server 2005 Express

    Anyone there who can help me solve my problem? I can’t continue my program because of this problem which I know someone can solve or can suggest the best possible solution. I have a project in my study doing simple accounting program. To facilitate the discussion, I will just show you the three...

    Ariell5 pointsBadges:
  • Writing a hidden trigger against a SQL table

    How do I write a hidden trigger against a SQL table?

    SQL Server Ask the Experts2,585 pointsBadges:
  • mixed 2000 db and 2007 mixed datepicker results

    I had an old access database (2000) and ported it to access 2007 all well and good then created a new date field in my form, now i get the datepicker option for the new field but none of the old date fields. any ideas how to get access 2007 to give date picker to my old date fields, i have already...

    Jarcher1230 pointsBadges:
  • 1:1 Modeling Inheritance 1:1

    I am working on a database to store employment history. A person can be employed by an organization or another person. I created the following tables: Person Organization Employer Employment Person and Organization both have a 1:1 relationship with Employer. Employer has a 1:M relationship with...

    Wolfrvr5 pointsBadges:
  • VBA to print to specific printer with print button

    In Access 2007 how do I use VBA code in my print button to print to a "specific printer" for my report.

    RPJ5 pointsBadges:
  • How to manage allocated register problems in RPG?

    Hello. I'm having troubles with many allocated registers for update, when 2 users try to modify the same data. How is the correct way to prevent this situation in ILERPG ? Thanks!

    Mariodlg2,790 pointsBadges:
  • foxprox 2.6 for DOS

    when programs (small or large) runs in foxprox 2.6 for DOS the CPU usage showing 100%. how can i solve this problem. pls answer me

    Anjalimanoj25 pointsBadges:
  • SQL Server 2000 script

    Hi , How can we use SQL 2000 script to call 2nd maximum date? case : Item A has few price with different effective_date, Ihow can i call an item's price with second max(effective_date). Thanks in advance.

    Beginer200825 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following