This is not a problem for Oracle server, because values NULL and '' in VARCHAR2 column are equivalent.
So it is enough to check t1.Question IS NULL
Search found 725 matches
- Tue 15 Sep 2009 08:11
- Forum: LinqConnect (LINQ to SQL support)
- Topic: IsNullOrEmpty not working correctly
- Replies: 6
- Views: 3394
- Tue 15 Sep 2009 08:02
- Forum: dotConnect for Oracle
- Topic: Missing query operator support in Devart.Data.Linq
- Replies: 1
- Views: 2159
- Fri 16 Jan 2009 11:54
- Forum: dotConnect for MySQL
- Topic: Trial doesn't work at all
- Replies: 10
- Views: 3833
- Wed 14 Jan 2009 17:26
- Forum: LinqConnect (LINQ to SQL support)
- Topic: Reverse engineering naming algorithm
- Replies: 2
- Views: 2898
Try to use the following steps:
1. Backup Template folder (in Entity Developer)
2. Remove all references to GetPluralName function in Template you use (CS or VB)
3. Restart Developer and try to Generate with reformed template.
4. If it won't help then restore the backup. Otherwise enjoy generated classes.
1. Backup Template folder (in Entity Developer)
2. Remove all references to GetPluralName function in Template you use (CS or VB)
3. Restart Developer and try to Generate with reformed template.
4. If it won't help then restore the backup. Otherwise enjoy generated classes.
- Fri 09 Jan 2009 15:34
- Forum: dbForge for Oracle
- Topic: conflict between OCL and stlport
- Replies: 1
- Views: 3437
- Thu 06 Nov 2008 10:17
- Forum: dotConnect for Oracle
- Topic: Licensing for MSTest during Team Build
- Replies: 3
- Views: 3525
You have to install OraDirect .NET on the computer where unit tests are compiled by Visual Studio (build server).
To avoid this you can build *.licenses resource as described in "Licensing"|"Compiling License Manually" section of OraDirect .NET documentation. Use your licenses.licx and licenses.config for compiling with lc.exe utility. Do this on the computer where OraDirect .NET is installed.
Then include *.licenses resource to unit tests and process tests as usual.
To avoid this you can build *.licenses resource as described in "Licensing"|"Compiling License Manually" section of OraDirect .NET documentation. Use your licenses.licx and licenses.config for compiling with lc.exe utility. Do this on the computer where OraDirect .NET is installed.
Then include *.licenses resource to unit tests and process tests as usual.
- Tue 04 Nov 2008 11:51
- Forum: dotConnect for MySQL
- Topic: DataLink.AddNew Problem
- Replies: 1
- Views: 2437
- Fri 03 Oct 2008 09:31
- Forum: dotConnect for MySQL
- Topic: question about linq2mysql and FK,PK relationships (MARS)
- Replies: 2
- Views: 2901
Thank you for your gratitudes. Please explain on a example which data loading you want to be "lazy"?
If your object "User" has property "UserProperties" of EntitySet type, it is
loaded from server when you are accessing User.UserProperties property.
If your object "User" has property "Company" of EntityRef type, it is
loaded from server when you are accessing User.Company property.
If you run query
var q = (from u in db.Users
select new { u , properties = from p in db.UserProperties where p.User == u select p});
then ".properties" is
loaded from server when you are accessing this property.
Intellisense in the IDE works with code of Microsoft Visual Studio. Our library starts working in run time only. Please check the type of m.Modulesinroless. Possibly it is a list.
MySQL Server does not support MARS (Multiple Active Result Sets). But it is not needed for running LINQ to MySQL. The library has its own solution for the problem and can work with multiple opened data readers at the same time.
If you have a question please write an example LINQ code and specify declaration for instance objects.
If your object "User" has property "UserProperties" of EntitySet type, it is
loaded from server when you are accessing User.UserProperties property.
If your object "User" has property "Company" of EntityRef type, it is
loaded from server when you are accessing User.Company property.
If you run query
var q = (from u in db.Users
select new { u , properties = from p in db.UserProperties where p.User == u select p});
then ".properties" is
loaded from server when you are accessing this property.
Intellisense in the IDE works with code of Microsoft Visual Studio. Our library starts working in run time only. Please check the type of m.Modulesinroless. Possibly it is a list.
MySQL Server does not support MARS (Multiple Active Result Sets). But it is not needed for running LINQ to MySQL. The library has its own solution for the problem and can work with multiple opened data readers at the same time.
If you have a question please write an example LINQ code and specify declaration for instance objects.
- Tue 30 Sep 2008 12:08
- Forum: dotConnect for Oracle
- Topic: Install error 1722
- Replies: 2
- Views: 2860
- Fri 19 Sep 2008 15:55
- Forum: dotConnect for Oracle
- Topic: Problem using OracleLoader
- Replies: 2
- Views: 2689
- Wed 17 Sep 2008 08:41
- Forum: dbForge for Oracle
- Topic: need some OCL help
- Replies: 2
- Views: 4786
There is no way in Oracle to determine if a connection is broken. OCI does not have such functionality. When the connection is broken, the next command execution returns an error. You can determine this situation by executing any simple command that does not affect data ("COMMIT" for example).
Function "isConnected()" returns the current state of OraConnection object and does not know anything about network socket state.
Can you reproduce "access the wrong memory point" error on a small application? What is your OCL version? Send us please small demo project to demonstrate the problem
and include script to create server objects (procedures, tables).
Function "isConnected()" returns the current state of OraConnection object and does not know anything about network socket state.
Can you reproduce "access the wrong memory point" error on a small application? What is your OCL version? Send us please small demo project to demonstrate the problem
and include script to create server objects (procedures, tables).
- Wed 17 Sep 2008 08:39
- Forum: dbForge for Oracle
- Topic: Oracle Connection with OCL
- Replies: 1
- Views: 4373
Please see the answer in this topic
http://devart.com/forums/viewtopic.php?p=38684#38684
http://devart.com/forums/viewtopic.php?p=38684#38684
- Mon 08 Sep 2008 10:07
- Forum: dbForge for Oracle
- Topic: Oracle Class Library for C++ Question
- Replies: 1
- Views: 4100
You can read about Oracle Class library for C++ here: http://devart.com/ocl/ It includes components OraConnection, OraCommand, OraRecordset, and many others. You can use them to execute statements and PL/SQL blocks.
- Wed 20 Aug 2008 16:59
- Forum: Oracle Data Access Components
- Topic: Oracle Class Library for C++ Builder 2007
- Replies: 2
- Views: 2194
- Mon 24 Dec 2007 13:29
- Forum: dotConnect for Oracle
- Topic: ORA-12516: TNS:listener could not find available handler with matching protocol stack
- Replies: 3
- Views: 7769
This probem happens on the Oracle server side. Possibly one of described solutions will help to solve this problem (http://forums.oracle.com/forums/thread. ... 9&tstart=0).
You can reproduce this problem with OraDirect .NET pooling because not all connections are used at once and peak of maximum created connections can come some time later after starting the process.
You can reproduce this problem with OraDirect .NET pooling because not all connections are used at once and peak of maximum created connections can come some time later after starting the process.