473,839 Members | 1,398 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Stored Proc error after modifying field type

Hi,
I've a problem with some of my stored procs. My config is: RH7.1, Postgres
7.3.2

I had converted a few fields of a few tables from one type to another and
after this I made all the necessary changes on the functions and recreated
all my types and functions.
It seemd to be all right, but the newly created functions won't work
anymore.

The error message says after running one of them:
-----------------------------------------------------------------------
ERROR: Function addincominginvo ice(integer, integer, "unknown", "unknown",
"unknown", "unknown", integer, "unknown", "unknown", "unknown", "unknown",
double precision) does not exist
Unable to identify a function that satisfies the given argument types
You may need to add explicit typecasts
-----------------------------------------------------------------------

This error rises only with newly created functions, old functions are workig
fine.

Should anybody suggest me something to avoid this problem.

Thanks a lot,

-- Csaba


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.491 / Virus Database: 290 - Release Date: 2003. 06. 18.
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)

Nov 11 '05 #1
7 3545
=?iso-8859-1?Q?Egy=FCd_Csa ba?= <cs*****@freema il.hu> writes:
ERROR: Function addincominginvo ice(integer, integer, "unknown", "unknown",
"unknown", "unknown", integer, "unknown", "unknown", "unknown", "unknown",
double precision) does not exist
Unable to identify a function that satisfies the given argument types


The error message may be misleading you --- that same error will be
reported when there is no possible match in pg_proc, and when there
are multiple matches and the system can't figure out which to pick.
(I plan to try to make this better in 7.4...) Given all the unknowns
you've got there, multiple matches seems like a likely problem.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 11 '05 #2
Hi Tom,
querying my functions results this:

alumil=# \df addincominginvo ice
List of functions
Result data type | Schema | Name |
Argument data types
------------------+--------+--------------------+---------------------------
---------------------------------------
integer | public | addincominginvo ice | integer, integer, text,
text, text, text, integer, text, text, text, text, numeric
(1 row)

This means that I have exactly one addincominginvo ice function, in addition
with the appropriate parameter list.

----------------------------------------------------------------------------
--------------------------------------
Calling this procedure from the console, it goes well.
alumil=# select addincominginvo ice (2, -1, 'xxxx', '2003.07.01',
'2003.07.01', 'DDDD', 25, '2003.09.01', 'f', ' ', 'f', 2332.334);
addincominginvo ice
--------------------
10
----------------------------------------------------------------------------
--------------------------------------

Calling it from the win32 client it fails. (The client is a Delphi 7
application using BDE)
The traffic between the client and the backend is the following:
----------------------------------------------------------------------------
--------------------------------------
1 17:59:12 SQL Prepare: PostgreSQL - { call "addincominginv oice"
(?,?,?,?,?,?,?, ?,?,?,?,?)}
2 17:59:12 SQL Misc: PostgreSQL - Set stored procedure on or off
3 17:59:12 SQL Data In: PostgreSQL - Param = 1, Name = PartnerID,
Type = fldINT32, Precision = 0, Scale = 0, Data = 19
4 17:59:12 SQL Data In: PostgreSQL - Param = 2, Name = OrderNumber,
Type = fldINT32, Precision = 0, Scale = 0, Data = -1
5 17:59:12 SQL Data In: PostgreSQL - Param = 3, Name = SN, Type =
fldZSTRING, Precision = 12, Scale = 0, Data = xxxxxxxxxxxx
6 17:59:12 SQL Data In: PostgreSQL - Param = 4, Name = PerformanceDat
e, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2003.07.02
7 17:59:12 SQL Data In: PostgreSQL - Param = 5, Name = IssuingDate,
Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2003.07.02
8 17:59:12 SQL Data In: PostgreSQL - Param = 6, Name = LedgerAccount,
Type = fldZSTRING, Precision = 7, Scale = 0, Data = YYYYYYY
9 17:59:12 SQL Data In: PostgreSQL - Param = 7, Name = UserID, Type =
fldINT32, Precision = 0, Scale = 0, Data = 25
10 17:59:12 SQL Data In: PostgreSQL - Param = 8, Name =
PaymentDeadLine , Type = fldZSTRING, Precision = 10, Scale = 0, Data =
2003.07.02
11 17:59:12 SQL Data In: PostgreSQL - Param = 9, Name = Payed, Type =
fldZSTRING, Precision = 1, Scale = 0, Data = f
12 17:59:12 SQL Data In: PostgreSQL - Param = 10, Name = PayedDate,
Type = fldZSTRING, Precision = 10, Scale = 0, Data =
13 17:59:12 SQL Data In: PostgreSQL - Param = 11, Name = NoStock, Type
= fldZSTRING, Precision = 1, Scale = 0, Data = f
14 17:59:12 SQL Data In: PostgreSQL - Param = 12, Name = GrossValue,
Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
15 17:59:12 SQL Execute: PostgreSQL - { call "addincominginv oice"
(:PartnerID,:Or derNumber,:SN,: PerformanceDate ,:IssuingDate,: LedgerAccount,: U
serID,:PaymentD eadLine,:Payed, :PayedDate,:NoS tock,:GrossValu e)}
16 17:59:12 SQL Vendor: ODBC - SQLAllocStmt
17 17:59:12 SQL Vendor: ODBC - SQLBindParamete r
18 17:59:12 SQL Vendor: ODBC - SQLBindParamete r
19 17:59:12 SQL Vendor: ODBC - SQLBindParamete r
20 17:59:12 SQL Vendor: ODBC - SQLBindParamete r
21 17:59:12 SQL Vendor: ODBC - SQLBindParamete r
22 17:59:12 SQL Vendor: ODBC - SQLBindParamete r
23 17:59:12 SQL Vendor: ODBC - SQLBindParamete r
24 17:59:12 SQL Vendor: ODBC - SQLBindParamete r
25 17:59:12 SQL Vendor: ODBC - SQLBindParamete r
26 17:59:12 SQL Vendor: ODBC - SQLBindParamete r
27 17:59:12 SQL Vendor: ODBC - SQLBindParamete r
28 17:59:12 SQL Vendor: ODBC - SQLBindParamete r
29 17:59:12 SQL Vendor: ODBC - SQLExecDirect
30 17:59:12 SQL Vendor: ODBC - SQLError
31 17:59:12 SQL Error: PostgreSQL - ERROR: Function
addincominginvo ice(integer, integer, "unknown", "unknown", "unknown",
"unknown", integer, "unknown", "unknown", "unknown", "unknown", double
precision) does not exist
Unable to identify a function that satisfies the given argument types
You may need to add explicit typecasts
32 17:59:12 SQL Vendor: ODBC - SQLError
33 17:59:12 SQL Stmt: PostgreSQL - Reset
34 17:59:12 SQL Vendor: ODBC - SQLFreeStmt

----------------------------------------------------------------------------
--------------------------------------
This trace is provided by the psqlODBC driver.
Can you find anything in this log, which can cause the error?

Thank you,
-- Csaba

----- Original Message -----
From: "Tom Lane" <tg*@sss.pgh.pa .us>
To: "Együd Csaba" <cs*****@freema il.hu>
Cc: <pg***********@ postgresql.org>
Sent: Wednesday, July 02, 2003 5:41 PM
Subject: Re: [GENERAL] Stored Proc error after modifying field type

=?iso-8859-1?Q?Egy=FCd_Csa ba?= <cs*****@freema il.hu> writes:
ERROR: Function addincominginvo ice(integer, integer, "unknown", "unknown", "unknown", "unknown", integer, "unknown", "unknown", "unknown", "unknown", double precision) does not exist
Unable to identify a function that satisfies the given argument types


The error message may be misleading you --- that same error will be
reported when there is no possible match in pg_proc, and when there
are multiple matches and the system can't figure out which to pick.
(I plan to try to make this better in 7.4...) Given all the unknowns
you've got there, multiple matches seems like a likely problem.

regards, tom lane

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.491 / Virus Database: 290 - Release Date: 2003. 06. 18.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 11 '05 #3
=?iso-8859-2?Q?Egy=FCd_Csa ba?= <cs*****@freema il.hu> writes:
alumil=# \df addincominginvo ice
List of functions
Result data type | Schema | Name |
Argument data types
------------------+--------+--------------------+---------------------------
---------------------------------------
integer | public | addincominginvo ice | integer, integer, text,
text, text, text, integer, text, text, text, text, numeric
(1 row) 31 17:59:12 SQL Error: PostgreSQL - ERROR: Function
addincominginvo ice(integer, integer, "unknown", "unknown", "unknown",
"unknown", integer, "unknown", "unknown", "unknown", "unknown", double
precision) does not exist


IIRC, there's no implicit cast from double precision to numeric, only
the other direction. You'll need to do something to persuade the ODBC
driver to select numeric not float as the parameter type. This is
outside my field --- you might get some help in pgsql-odbc.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 11 '05 #4
Sorry for posting many times!
-- Csaba
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.491 / Virus Database: 290 - Release Date: 2003. 06. 18.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 11 '05 #5
Thank you Tom,
I'll check it out. But I must say that I have many other functions using
numeric fields and working well.
This error has been rising up since I converted my fields from double
precision to numeric.
May be the problem is in my ODBC settings but I'm sceptic a bit about this.
I had set the
"Int8 As numeric" option before converting my fields.

Anyway, I subscript pgsql-odbc list.

Thank you very much.

-- Csaba

----- Original Message -----
From: "Tom Lane" <tg*@sss.pgh.pa .us>
To: "Együd Csaba" <cs*****@freema il.hu>
Cc: <pg***********@ postgresql.org>
Sent: Wednesday, July 02, 2003 6:23 PM
Subject: Re: [GENERAL] Stored Proc error after modifying field type

=?iso-8859-2?Q?Egy=FCd_Csa ba?= <cs*****@freema il.hu> writes:
alumil=# \df addincominginvo ice
List of functions Result data type | Schema | Name |
Argument data types


------------------+--------+--------------------+-------------------------

--
---------------------------------------
integer | public | addincominginvo ice | integer, integer, text, text, text, text, integer, text, text, text, text, numeric
(1 row)

31 17:59:12 SQL Error: PostgreSQL - ERROR: Function
addincominginvo ice(integer, integer, "unknown", "unknown", "unknown",
"unknown", integer, "unknown", "unknown", "unknown", "unknown", double
precision) does not exist


IIRC, there's no implicit cast from double precision to numeric, only
the other direction. You'll need to do something to persuade the ODBC
driver to select numeric not float as the parameter type. This is
outside my field --- you might get some help in pgsql-odbc.

regards, tom lane

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.491 / Virus Database: 290 - Release Date: 2003. 06. 18.
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 11 '05 #6
Tom,
what do you think about the folowing: I updated the server field of my DSN
to point to the postgres runniong under cygwin on the localhost. The error
does not appear at all.
----------------------------------
1 06:29:42 SQL Prepare: PostgreSQL - { call "addincominginv oice"
(?,?,?,?,?,?,?, ?,?,?,?,?)}
2 06:29:42 SQL Misc: PostgreSQL - Set stored procedure on or off
3 06:29:42 SQL Data In: PostgreSQL - Param = 1, Name = PartnerID,
Type = fldINT32, Precision = 0, Scale = 0, Data = 3
4 06:29:42 SQL Data In: PostgreSQL - Param = 2, Name = OrderNumber,
Type = fldINT32, Precision = 0, Scale = 0, Data = -1
5 06:29:42 SQL Data In: PostgreSQL - Param = 3, Name = SN, Type =
fldZSTRING, Precision = 20, Scale = 0, Data = AAAAAAAAAAAAAAA AAAAA
6 06:29:42 SQL Data In: PostgreSQL - Param = 4, Name =
PerformanceDate , Type = fldZSTRING, Precision = 10, Scale = 0, Data =
2003.07.03
7 06:29:42 SQL Data In: PostgreSQL - Param = 5, Name = IssuingDate,
Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2003.07.03
8 06:29:42 SQL Data In: PostgreSQL - Param = 6, Name = LedgerAccount,
Type = fldZSTRING, Precision = 10, Scale = 0, Data = BBBBBBBBBB
9 06:29:42 SQL Data In: PostgreSQL - Param = 7, Name = UserID, Type =
fldINT32, Precision = 0, Scale = 0, Data = 25
10 06:29:42 SQL Data In: PostgreSQL - Param = 8, Name =
PaymentDeadLine , Type = fldZSTRING, Precision = 10, Scale = 0, Data =
2003.07.03
11 06:29:42 SQL Data In: PostgreSQL - Param = 9, Name = Payed, Type =
fldZSTRING, Precision = 1, Scale = 0, Data = f
12 06:29:42 SQL Data In: PostgreSQL - Param = 10, Name = PayedDate,
Type = fldZSTRING, Precision = 10, Scale = 0, Data =
13 06:29:42 SQL Data In: PostgreSQL - Param = 11, Name = NoStock, Type
= fldZSTRING, Precision = 1, Scale = 0, Data = f
14 06:29:42 SQL Data In: PostgreSQL - Param = 12, Name = GrossValue,
Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
15 06:29:42 SQL Execute: PostgreSQL - { call "addincominginv oice"
(:PartnerID,:Or derNumber,:SN,: PerformanceDate ,:IssuingDate,: LedgerAccount,: U
serID,:PaymentD eadLine,:Payed, :PayedDate,:NoS tock,:GrossValu e)}
16 06:29:42 SQL Vendor: ODBC - SQLAllocStmt
17 06:29:42 SQL Vendor: ODBC - SQLBindParamete r
18 06:29:42 SQL Vendor: ODBC - SQLBindParamete r
19 06:29:42 SQL Vendor: ODBC - SQLBindParamete r
20 06:29:42 SQL Vendor: ODBC - SQLBindParamete r
21 06:29:42 SQL Vendor: ODBC - SQLBindParamete r
22 06:29:42 SQL Vendor: ODBC - SQLBindParamete r
23 06:29:42 SQL Vendor: ODBC - SQLBindParamete r
24 06:29:42 SQL Vendor: ODBC - SQLBindParamete r
25 06:29:42 SQL Vendor: ODBC - SQLBindParamete r
26 06:29:42 SQL Vendor: ODBC - SQLBindParamete r
27 06:29:42 SQL Vendor: ODBC - SQLBindParamete r
28 06:29:42 SQL Vendor: ODBC - SQLBindParamete r
29 06:29:42 SQL Vendor: ODBC - SQLExecDirect
30 06:29:42 SQL Vendor: ODBC - SQLNumResultCol s
31 06:29:42 SQL Vendor: ODBC - SQLDescribeCol
32 06:29:42 SQL Misc: PostgreSQL - Set rowset size
33 06:29:42 SQL Vendor: ODBC - SQLBindCol
34 06:29:42 SQL Stmt: PostgreSQL - Fetch
35 06:29:42 SQL Vendor: ODBC - SQLSetStmtOptio n
36 06:29:42 SQL Vendor: ODBC - SQLExtendedFetc h
37 06:29:42 SQL Data Out: PostgreSQL - Column = 1, Name =
addincominginvo ice, Type = fldINT32, Precision = 10, Scale = 0, Data = 18
38 06:29:42 SQL Stmt: PostgreSQL - Reset
39 06:29:42 SQL Vendor: ODBC - SQLFreeStmt
40 06:29:42 SQL Stmt: PostgreSQL - Close
41 06:29:42 SQL Stmt: PostgreSQL - Reset
42 06:29:42 SQL Vendor: ODBC - SQLFreeStmt
43 06:29:42 SQL Stmt: PostgreSQL - Close
44 06:29:42 SQL Prepare: PostgreSQL - select count(*) as count from
t_incoming_invo ices;
----------------------------------
But the following function fails:
----------------------------------
1 06:33:06 SQL Prepare: PostgreSQL - { call "addinstalm ent" (?,?,?)}
2 06:33:06 SQL Misc: PostgreSQL - Set stored procedure on or off
3 06:33:06 SQL Data In: PostgreSQL - Param = 1, Name = InvoiceID,
Type = fldINT32, Precision = 0, Scale = 0, Data = 35
4 06:33:06 SQL Data In: PostgreSQL - Param = 2, Name = PayDate, Type
= fldZSTRING, Precision = 10, Scale = 0, Data = 2003.04.18
5 06:33:06 SQL Data In: PostgreSQL - Param = 3, Name = Instalment,
Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1000.000000
6 06:33:06 SQL Execute: PostgreSQL - { call "addinstalm ent"
(:InvoiceID,:Pa yDate,:Instalme nt)}
7 06:33:06 SQL Vendor: ODBC - SQLAllocStmt
8 06:33:06 SQL Vendor: ODBC - SQLBindParamete r
9 06:33:06 SQL Vendor: ODBC - SQLBindParamete r
10 06:33:06 SQL Vendor: ODBC - SQLBindParamete r
11 06:33:06 SQL Vendor: ODBC - SQLExecDirect
12 06:33:06 SQL Vendor: ODBC - SQLError
13 06:33:06 SQL Error: PostgreSQL - ERROR: Function
addinstalment(i nteger, "unknown", double precision) does not exist
Unable to identify a function that satisfies the given argument types
You may need to add explicit typecasts
14 06:33:06 SQL Vendor: ODBC - SQLError
15 06:33:06 SQL Stmt: PostgreSQL - Reset
16 06:33:06 SQL Vendor: ODBC - SQLFreeStmt
17 06:33:09 SQL Stmt: PostgreSQL - Close
----------------------------------
alumil=# \df addinstalment
List of functions
Result data type | Schema | Name | Argument data types
------------------+--------+---------------+------------------------
integer | public | addinstalment | integer, text, numeric
(1 row)
----------------------------------

Do you think yet the ODBC can be balmed. I don't know what to think.

-- Csaba
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.491 / Virus Database: 290 - Release Date: 2003. 06. 18.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 11 '05 #7
Hi,
I got out of this problem, but I'm not sure I found the best way.
I changed the parameter types of my functions from decimal to text. It
results, that I can send string values for decimal fields. This works well,
but I don't know if it is leading to other problems or not.

Thank you,

-- Csaba


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.491 / Virus Database: 290 - Release Date: 2003. 06. 18.
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 11 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
4007
by: KathyB | last post by:
I'm trying to concatenate fields in SQL stored proc for use in text field in asp.net dropdownlist. I'm running into a problem when I try to use a DateTime field, but can't find the answer (so far) on the Internet. Was hoping someone here would know? My sql stored proc: SELECT AnomalyID, DateEntered + ', ' + Station + ', ' + Problem As 'SelectInfo' FROM tblAnomaly
2
5130
by: xAvailx | last post by:
I have a requirement that requires detection of rows deleted/updated by other processes. My business objects call stored procedures to create, read, update, delete data in a SQL Server 2000 data store. I've done a fair amount of research on concurrency handling in newsgroups and other resources. Below is what I've come up as a standard for handling concurrency thru stored procedures. I am sharing with everyone so I can get some comments...
0
593
by: Együd Csaba | last post by:
Hi, I've a problem with some of my stored procs. My config is: RH7.1, Postgres 7.3.2 I have converted a few fields of a few tables from one type to another. After this I made all the necessary changes on the functions and recreated all my types and functions. (Actually I recreated the whole database later from a dump.) It seemd to be all right, but some functions won't work anymore. I call them from a windows client program (Delphi via...
0
1214
by: Együd Csaba | last post by:
> Hi, > I've a problem with some of my stored procs. My config is: RH7.1, Postgres > 7.3.2 > > I had converted a few fields of a few tables from one type to another and > after this I made all the necessary changes on the functions and recreated > all my types and functions. > It seemd to be all right, but the newly created functions won't work > anymore. >
4
4408
by: Nyul | last post by:
Gurus, I have a verb big problem which I'm unable to explain. We have a DB2 V6.1.0 on AIX 4.3 I want to make a C stored procedure which at the end will be called by a PHP script. The development server was an UDB V6.1.0 on W2K. Everything went well. I was able to call the stored proc from C and from Delphi.
4
3197
by: Rhino | last post by:
Is it possible for a Java Stored Procedure in DB2 V7.2 (Windows) to pass a Throwable back to the calling program as an OUT parameter? If yes, what datatype should I use when registering the Throwable as an OUT parameter and what datatype should I use in the CREATE PROCEDURE and DROP PROCEDURE statements? Here's what I tried: - the method signature for the stored procedure included: Throwable throwable
5
2258
by: Rob Wire | last post by:
For the code below, how could I add an item in the drop down lists for both company and location to be an "All" selection that would send to the stored proc. spRptAttachments a value of "%" so that it would bring back all attachments at all companies or all locations at a company? Thank you, Rob. Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load If Not IsPostBack Then
3
1522
by: Byron | last post by:
I'm trying to iterate stored parameters and populate any public properties of an object with the parameter value. I've suceeded in doing it the other way around, but when I try it to the object I keep getting the error "Object does not match target type". I've tried field.SetValue(p, p.Value, BindingFlags.SetField, null, null, null) and a couple variations without sucess. Thanks in advance for any help you can offer.
0
1995
by: mirandacascade | last post by:
Questions toward the bottom of the post. Situation is this: 1) Access 97 2) SQL Server 2000 3) The Access app: a) sets up pass-thru query b) .SQL property of querydef is a string, the contents of which comprise the call to a stored proc
0
9856
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9698
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10911
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10589
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10298
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7833
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7021
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5683
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
3
3136
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.