Below is my code for adding parameters in my vb .net code for prepared statements of npgsql. Dim xConn As NpgsqlConnection = ConnectDB() Dim xCmd As NpgsqlCommand = xConn.CreateCommand() xCmd.CommandText = "UPDATE " & xTable & " SET previous_tot_adj = @prev_adj ,tot_adj = @tot_adj WHERE version = " & _version & " AND monthly_mq_id = @Index" For Each Index In _Results.Keys If Not IsNothing(_Results.Item(Index)) Then xCmd.Parameters.AddWithValue("prev_adj", NpgsqlTypes.NpgsqlDbType.Double, _Results.Item(Index)) xCmd.Parameters.AddWithValue("tot_adj", NpgsqlTypes.NpgsqlDbType.Double, _Results.Item(Index)) xCmd.Parameters.AddWithValue("Index", NpgsqlTypes.NpgsqlDbType.Bigint, Index) End If Next xCmd.Prepare() xCmd.ExecuteNonQuery() After executing this code i get this kind of error . > A first chance exception of type 'Npgsql.NpgsqlException' occurred in …

Member Avatar
Member Avatar
+0 forum 2

Can anyone show on how can i move an image on an excel sheet to a specific cell. Thank you in advance.

Member Avatar
Member Avatar
+0 forum 7

I always feel sleepy at work . During afternoon..

Member Avatar
Member Avatar
+1 forum 32

I have this code. pdfCreator.ActiveSheet.PrintOut copies:=1, ActivePrinter:= _ "PDF Complete on PDFC", collate:=True How can i add a save location to this code . My default is the desktop when i save all the the file to be converted my desktop becomes a mess . can anyone help me how can i save it to a specific location. thank you!!

Member Avatar
Member Avatar
+1 forum 4

DOes anybody here know how to use send key for alt+s . can you please tell me how to do it. thank you!!

Member Avatar
Member Avatar
+0 forum 6

The default print area is upto cell H how can i extend it to I? Can anyone here help me .. thank you.

Member Avatar
+1 forum 0

hahaha .. :P .. lets see who is the best here.

Member Avatar
Member Avatar
+1 forum 2

Do anyone here Know how to get the previous month of a given date.. Example given date: 11/25/2012 Output: 10/25/2012 thank you.. i know you can help me ..

Member Avatar
Member Avatar
+1 forum 3

Hi, i have a form and i have 2 input box. Is there any way to restore the last input in reopening the Form. 'is there any code like this? userform1.input_date.value = userform1.input_date.lastValue Thank you in advance.

Member Avatar
Member Avatar
+0 forum 2

CAn anyone help me how to create a file browser using excel macro? Thank you guyss.

Member Avatar
Member Avatar
+0 forum 2

The End.