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: [...]
Answer Question
| December 17, 2008 3:38 PM
Access query, IIF statement, Microsoft Access, SQL, Wildcards
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: [...]
Answer Question
| December 17, 2008 3:38 PM
Access query, IIF statement, Microsoft Access, SQL, Wildcards
Clustered and Non-clustered Index
Hi, I have one table having more than 3 millions rows with following columns: [SITE_ID] [USER_NAME]
Answer Question
| December 17, 2008 1:51 PM
Clustered Index, Non-Clustered Index, Query optimization
Hi, I have one table having more than 3 millions rows with following columns: [SITE_ID] [USER_NAME]
Answer Question
| December 17, 2008 1:51 PM
Clustered Index, Non-Clustered Index, Query optimization
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
Answer Question
| December 17, 2008 1:27 PM
ADO Recordset Object, Microsoft Access, VB 6.0
How to pass Parameters in MS Access into Vb 6.0 and get the results through ado recordset
Answer Question
| December 17, 2008 1:27 PM
ADO Recordset Object, Microsoft Access, VB 6.0
Multiple instances with SQL Server
Is it adviceable to put SQL 2000 and 2005 in one single CLuster by putting them in different instances?
Answer Question
| December 17, 2008 8:56 AM
Database instance, SQL Server 2000, SQL Server 2005, SQL Server clustering, SQL Server multiple instances
Is it adviceable to put SQL 2000 and 2005 in one single CLuster by putting them in different instances?
Answer Question
| December 17, 2008 8:56 AM
Database instance, SQL Server 2000, SQL Server 2005, SQL Server clustering, SQL Server multiple instances
How to connect PowerBuilder 10 with Microsoft SQL Server?
connect Powerbuilder 10 with Microsoft SQL??
Answer Question
| June 15, 2010 6:43 AM
Database connectivity, PowerBuilder, PowerBuilder 10, RAD, Rapid Application Development, SQL Server connectivity, SQL Server interoperability
connect Powerbuilder 10 with Microsoft SQL??
Answer Question
| June 15, 2010 6:43 AM
Database connectivity, PowerBuilder, PowerBuilder 10, RAD, Rapid Application Development, SQL Server connectivity, SQL Server interoperability
SERVER
hi my name is Harry, and and am studying IT. this mode i have Windows Server 2003, how important is it in the field?
Answer Question
| December 16, 2008 3:53 PM
IT careers, Windows Server 2003
hi my name is Harry, and and am studying IT. this mode i have Windows Server 2003, how important is it in the field?
Answer Question
| December 16, 2008 3:53 PM
IT careers, Windows Server 2003
Use of multiple SET/WHERE clauses in the MERGE of 2 Oracle tables
Currently am able to update 1 Oracle table from another using MERGE along with WHEN MATCHED THEN UPDATE logic. Under the UPDATE command I am using a SET/WHERE to update a specific column based on certain criteria. I want to add another SET/WHERE condition to this same update which will result in an UPDATE of [...]
Answer Question
| December 23, 2008 3:49 PM
MERGE statement, Oracle Table, PL/SQL, SET/WHERE
Currently am able to update 1 Oracle table from another using MERGE along with WHEN MATCHED THEN UPDATE logic. Under the UPDATE command I am using a SET/WHERE to update a specific column based on certain criteria. I want to add another SET/WHERE condition to this same update which will result in an UPDATE of [...]
Answer Question
| December 23, 2008 3:49 PM
MERGE statement, Oracle Table, PL/SQL, SET/WHERE
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 am using execute immediate [...]
Answer Question
| December 17, 2008 12:54 PM
ALTER INDEX statement, EXECUTE IMMEDIATE statement, Oracle development, Oracle SQL, Oracle stored procedures, SQL statements, Stored Procedures
‘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 am using execute immediate [...]
Answer Question
| December 17, 2008 12:54 PM
ALTER INDEX statement, EXECUTE IMMEDIATE statement, Oracle development, Oracle SQL, Oracle stored procedures, SQL statements, Stored Procedures
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 [...]
Answer Question
| December 18, 2008 12:45 PM
DBMS_LOCK.SLEEP, PL/SQL, PL/SQL block, SLEEP Procedure
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 [...]
Answer Question
| December 18, 2008 12:45 PM
DBMS_LOCK.SLEEP, PL/SQL, PL/SQL block, SLEEP Procedure
How to configure the database instance to respond slowly for any request?
With default configuration settings at DB instance, the db server is responding quick. For my tests, i want the db server response to be slow. What configuration changes or anything else can be done so that the db instance will respond slowly (atleast take 1 minute time to execute). The request can be connect to [...]
Answer Question
| December 24, 2008 7:24 AM
Database configuration, Database instance, Database testing, DB2, Oracle, SQL Database, SQL Query, SQL Server
With default configuration settings at DB instance, the db server is responding quick. For my tests, i want the db server response to be slow. What configuration changes or anything else can be done so that the db instance will respond slowly (atleast take 1 minute time to execute). The request can be connect to [...]
Answer Question
| December 24, 2008 7:24 AM
Database configuration, Database instance, Database testing, DB2, Oracle, SQL Database, SQL Query, SQL Server
Best SAP module for career change to SAP?
Hai, I have over 5 years of Production experience in Electronic Industry.I am currently working as Dot Net Developer in software company from 1 year.I am planning to switch my career to SAP. I am not sure which module to help in my career and where to begin with.i dont have any knowledge of SAP.Any [...]
Answer Question
| December 15, 2008 9:13 AM
Career development, IT careers, SAP careers, SAP jobs, SAP modules
Hai, I have over 5 years of Production experience in Electronic Industry.I am currently working as Dot Net Developer in software company from 1 year.I am planning to switch my career to SAP. I am not sure which module to help in my career and where to begin with.i dont have any knowledge of SAP.Any [...]
Answer Question
| December 15, 2008 9:13 AM
Career development, IT careers, SAP careers, SAP jobs, SAP modules
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 unclear on this please [...]
Answer Question
| December 17, 2008 6:56 AM
INSERT statement, OUT parameters, PL/SQL, PL/SQL block, SELECT statement, SQL statements
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 unclear on this please [...]
Answer Question
| December 17, 2008 6:56 AM
INSERT statement, OUT parameters, PL/SQL, PL/SQL block, SELECT statement, SQL statements
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 tables where [...]
Answer Question
| December 15, 2008 2:16 PM
INSERT statement, SQL Server 2005, SQL Server 2005 error messages, SQL Server 2005 Express, SQL Server stored procedures, Stored Procedures, VB.NET, Visual Basic .NET
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 tables where [...]
Answer Question
| December 15, 2008 2:16 PM
INSERT statement, SQL Server 2005, SQL Server 2005 error messages, SQL Server 2005 Express, SQL Server stored procedures, Stored Procedures, VB.NET, Visual Basic .NET
SBS 2003, SQL Server 2005 and database mirroring
Hello! I m trying to get db mirroring to work between two sbs 2003 premium based sql (2005) servers. Am I just plain stupid or did I miss sth? And please dont tell me about traceflags becaouse they dont seem to have an effect on my … problem? Perhaps I came out as a bastard [...]
Answer Question
| December 22, 2008 11:21 AM
Database mirroring, SBS, SBS 2003, SBS 2003 mirroring, Small Business Server 2003, SQL Server 2005, SQL Server 2005 mirroring
Hello! I m trying to get db mirroring to work between two sbs 2003 premium based sql (2005) servers. Am I just plain stupid or did I miss sth? And please dont tell me about traceflags becaouse they dont seem to have an effect on my … problem? Perhaps I came out as a bastard [...]
Answer Question
| December 22, 2008 11:21 AM
Database mirroring, SBS, SBS 2003, SBS 2003 mirroring, Small Business Server 2003, SQL Server 2005, SQL Server 2005 mirroring
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 [...]
Answer Question
| December 17, 2008 7:39 PM
Database programming, Microsoft Access
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 [...]
Answer Question
| December 17, 2008 7:39 PM
Database programming, Microsoft Access
I have metallurgical background with 7+ yrs experience. Is SAP suitable for me?
I am J S thakur and having more than 07years of experiance in steel production departement. My qualification is Diploma in metallurgy.Now i want to pursue my career in sap. is this suitable for me by consideration of my qualification. If yes which module is good for me.your suggestions shows me the way for bright [...]
Answer Question
| December 15, 2008 4:30 AM
Career development, IT careers, IT jobs, SAP careers, SAP jobs
I am J S thakur and having more than 07years of experiance in steel production departement. My qualification is Diploma in metallurgy.Now i want to pursue my career in sap. is this suitable for me by consideration of my qualification. If yes which module is good for me.your suggestions shows me the way for bright [...]
Answer Question
| December 15, 2008 4:30 AM
Career development, IT careers, IT jobs, SAP careers, SAP jobs
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 Bitmap(ms1); return signature; } I used the same code [...]
Answer Question
| December 15, 2008 2:35 AM
Binary data, Bitmap, MemoryStream class, PictureBox class, Software development
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 Bitmap(ms1); return signature; } I used the same code [...]
Answer Question
| December 15, 2008 2:35 AM
Binary data, Bitmap, MemoryStream class, PictureBox class, Software development
Retrieving the ‘SA’ password
By mistake I deleted my SA account. Now I am unable to access the isql I had done. I know that if you have lost the ‘SA’ password, then you can regenerate another one. I followed the steps outlined in the SearchEnterpriseLinux ATE answer on the topic of regenerating an SA password. But nothing happened [...]
Answer Question
| August 30, 2009 10:10 PM
Linux, Linux Commands, SA password, Sysbase
By mistake I deleted my SA account. Now I am unable to access the isql I had done. I know that if you have lost the ‘SA’ password, then you can regenerate another one. I followed the steps outlined in the SearchEnterpriseLinux ATE answer on the topic of regenerating an SA password. But nothing happened [...]
Answer Question
| August 30, 2009 10:10 PM
Linux, Linux Commands, SA password, Sysbase
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 [...]
Answer Question
| December 15, 2008 8:34 PM
Access 2003, ADO, Microsoft Access, VBA, Vertical Data
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 [...]
Answer Question
| December 15, 2008 8:34 PM
Access 2003, ADO, Microsoft Access, VBA, Vertical Data
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 Employment. Is this an acceptable way to model the [...]
Answer Question
| December 12, 2008 6:22 PM
Database, Database design, Modeling Inheritance
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 Employment. Is this an acceptable way to model the [...]
Answer Question
| December 12, 2008 6:22 PM
Database, Database design, Modeling Inheritance
