In FormA, I have a start_date and end_date fields for users to select the date range. The start_date and end_date will pass to FormB.subform where the subform is a continous form to display the records after filtered by the date range. My question is: how can I pass the date range to the subform of [...]
Answer Question | April 25, 2008 2:28 AM
Category: SQL Server 2005, T-SQL I have an insert trigger on TableA that updates Column1 in TableA. I also have an update trigger on TableA that I don’t want to fire, or at least not to execute certain code, when a new record is inserted in the table. How can this be achieved? I don’t [...]
Answer Question | April 23, 2008 5:34 PM
SQL Server, SQL Server 2005, T/SQL, Triggers
Hi, I have a continuous subform that, upon opening the database, flickers constantly. This flickering can be stopped either by alt-tabbing away from Access and back again or by hitting F9. The main form has a button that changes the source object of the subframe to a different continuous subform, and the same behavior is [...]
Answer Question | April 22, 2008 3:23 PM
Database, Microsoft Access
I have exported one dataset ‘IN105.Nord1′through QMF , then I have edited it and now I want to import it in QMF by same name( i.e IN105.Nord1′) which I can do it through QMF . But now I would like to achieve same thing by running QMF through jcls( i.e through batch).Can I replace edited [...]
Answer Question | April 22, 2008 10:59 AM
how to import GAL in microsoft exchange 2003 from csv
Answer Question | April 22, 2008 10:34 AM
CSV, Exchange 2003, GAL
Is it possible to access DB2 (V5R1) indexes from the Visual Linking Expert screen in Crystal Reports(8) and if so how?
Answer Question | September 23, 2009 10:31 AM
AS/400 DB2, Crystal Reports, Crystal Reports 8, DB2, Indexes, V5R1
I’m having problems replicating a table that has full-text enabled using sql server 2000 sp4. When I start the distribution agent I get the following error: Cannot use a CONTAINS or FREETEXT predicate on table ‘dbo.proposals’ because it is not full-text indexed. I have run sp_fulltext_database ‘enable’ on the subscriber. What do I need to [...]
Answer Question | April 22, 2008 6:14 PM
Full-text databases, SQL Server 2000, SQL Server replication
Can you help me solve the following problem. Whenever i have an order where the field Audit = True, i will have to delete all the previous orders having the Audit = True. And only when customerid = 121. With other words i have to delete the previous orders having Audit = true but not [...]
Answer Question | April 18, 2008 5:53 PM
Access 2000, Database, DELETE statement
I’ve just installed SQL Server Express and I want to create a local instance. I would like to use SQL Server to do my analysis in running queries instead of Microsoft Access. I want to import my tables from Access to SQL Server Express. How can I migrate from MS Access to SQL Server?
Answer Question | April 18, 2008 1:01 PM
Microsoft Access, SQL Server Express Edition, SQL Server migration
i am currently trying to break into the IT field and im am taking my A++ and Net+ certs in the next two months. i am doing this on my own and have no college education under my belt. i have also been working as a mechanic for the past seven years. is there any [...]
Answer Question | April 19, 2008 1:50 AM
A+, Certifications, IT careers, Network+
I need to be able to count how many values are greater than 1 for each StuNum. I have only been able to count how many values are greater than 1 for each StuNum for d1 or for d2 or for d3, but not for d1, d2 and d3. How can I have it count [...]
Answer Question | April 18, 2008 10:58 PM
COUNT, GROUP BY statement, SQL
Two tables, First Table –FN—LN—-Reasons John | Doe | 6 | Jane | Doe | 2 | —————– That’s the end of the first table. Second Table —Reason—-Reason Detail—– 2 | Invalid SSN 4 | Invalid Date Of Birth ————————————– That’s the end of the second table. (*Note, there is NO value of ’6′ in [...]
Answer Question | April 20, 2012 11:37 PM
Database, Developers, Development, Query, Query tuning, SQL, SQL Query
Our database was designed with separate fields for cc, yy, mm and dd. I’d like to know if and how these fields can be combined into one field then order by on that field. Is this possible? I would need to know the syntax also. If this is not possible, then is there a another [...]
Answer Question | April 17, 2008 1:14 PM
Concatenate, Database, RPG, SQL
We have a call to QMF from all the screen in the application. We also has QMF report generation from onlines where users enter the details in onlines which is passed to QMF proc and report is shown to them on QMF screen. Once user is done with QMF queries/reports and presses PF3 he/she returns [...]
Answer Question | April 16, 2008 5:20 AM
CICS, COBOL, Mainframe, QMF
Our db group wants to remove ODBC access. My application relies on ODBC to get data. What are the alternatives?
Answer Question | April 17, 2008 7:52 PM
Database connectivity, ODBC, SQL
Hi, I have done my B.Sc in Chemistry and then MBA in HR. Presently I am working with consultancy as IT Recruiter and having around 3 yrs exp. Now i don’t want to continue with Recruitment and want to sift into Technical side. I am thinking to do DBA or Datawarehousing course. Can anyone guide [...]
Answer Question | December 29, 2012 1:31 PM
Career development, DBA, IT careers
When i use Crystal Report 10, i alwaya found FULL OUTER JOIN option as disable. How to enable this option ?
Answer Question | April 19, 2008 9:32 AM
Crystal Reports, Database, FULL OUTER JOIN
can any one help with a lost past word for data file.
Answer Question | April 15, 2008 8:09 PM
Password, Symantec, Symantec Q&A
Can I have multiple Distributors configured on one SQL Server instance? Also, can I have multiple Distributors configured on one SQL Server instance? Finally, can I have multiple Subscribers configured on one SQL Server instance?
Answer Question | April 16, 2008 3:40 PM
SQL database replication, SQL Server, SQL Server administration
Hi! could somebody help us advice on what to do and what to prepare if we are going to migration our current database Betrieve tables to MS SQL Server 2005? Thanks. Note: We are currently accessing the Betrieve tables thru PervasiveSQL v8 engine.
Answer Question | May 8, 2008 8:10 AM
Data migration, Database migration, Migration, Pervasive, SQL Server 2005, SQL Server migration