Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1233
  • Last Modified:

Pervasive SQL parameter Criteria "?" identifier

I am connecting to a Pervaive 10 DB through VS 2008 (dataset)  All is working fine, but when I have more than 1 filter, all I can see is "?" for the paramater prompt.  Is there a way to Identify is like SQL server or Access like "@Param1" <-  does not work BTW.

Thanks.
0
vwalla
Asked:
vwalla
1 Solution
 
mirtheilCommented:
Nope. PSQL uses the "?" for it's parameter identifier.  
Attached is a code sample using C# and the PSQL ADO.NET provider.


using System;
using Pervasive.Data.SqlClient;
 
namespace PsqlParamTest
{
	class PsqlParamTest
	{
		[STAThread]
		static void Main(string[] args)
		{
			try
			{
				PsqlConnection con = new PsqlConnection("ServerDSN=demodata;ServerName=localhost");
				con.Open();
				PsqlCommand cmd = new PsqlCommand("CREATE TABLE PsqlParamDate ( f1 char(10), f2 LongVarChar)",con);
				int iRes = 0;
				iRes = cmd.ExecuteNonQuery();
				Console.WriteLine("Records affected: {0}",iRes);
				cmd.Dispose();
				PsqlCommand cmd1 = new PsqlCommand("INSERT INTO lvctest (f1,f2) values ( ?,?)",con);
				PsqlParameter param1 = new PsqlParameter("@param1", PsqlDbType.Char);
				param1.Value = "1234";
				cmd1.Parameters.Add(param1);
				PsqlParameter param2 = new PsqlParameter("@param2", PsqlDbType.LongVarChar);
				string sTemp = "";
				sTemp = "Test Value";
				
				param2.Value = sTemp; 
				cmd1.Parameters.Add(param2);
				iRes = cmd1.ExecuteNonQuery();
				Console.WriteLine("Records affected: {0}",iRes);
				cmd1.Dispose();
				con.Close();
				con.Dispose();
			}
			catch (Exception ex)
			{
				Console.WriteLine(ex.ToString());
			}
		}
	}
}

Open in new window

0
 
vwallaAuthor Commented:
That's what i thought.  Get's confusing sometimes what order I am putting it all in.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now