I use Blanks in ColumnNames ( I know that this isn´t very good, but a
lot of code and querys had to be changed if I would remove all blanks
in all columnnames).
When I link this tables with ODBC in my ACC97 - project, some of the
tables causes an ODBC-Error.
Are there possibilities to workaround this error?
Thanks, Andreas Lauffer, easySoft. GmbH, Germany 2 1852
You don't quite mention what you are linking to. (or what you are linking
from).
If you are using ms-access, then you are NOT using odbc if you are linking
to a back end table. That is a file share...and NOT ODBC.
However, you can usually put square brackets around the field name when
using JET.
[City Name] for example.
You are correct that most databases like sql-server etc don't support blanks
in the field names. A hard lesson to learn!
selectCityFromT ableTest
select City From TableTest
As you can see, spaces are delimiter used to separate each keyword. Thus, it
is query easy to see how this should be avoided. You should not use spaces
for all objects such as reports, forms, modules, and yes..even field
names...
--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada ka****@msn.com http://www.attcanada.net/~kallal.msn
Thanks for your answer. You don't quite mention what you are linking to. (or what you are linking from).
OK, from Access97 to SQL-Server. If you are using ms-access, then you are NOT using odbc if you are linking to a back end table. That is a file share...and NOT ODBC.
But the linked table have a ODBC-Connect-String. I use a DSN-less
connection. However, you can usually put square brackets around the field name when using JET.
I could´t use brackets, because I just open the linked table in the
speadsheat-view (double-click), and got ODBC-Error, and all fields
contain #Name? [City Name] for example.
You are correct that most databases like sql-server etc don't support blanks in the field names. A hard lesson to learn!
selectCityFrom TableTest
select City From TableTest
As you can see, spaces are delimiter used to separate each keyword. Thus, it is query easy to see how this should be avoided. You should not use spaces for all objects such as reports, forms, modules, and yes..even field names... This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Jon Glazer |
last post by:
I know this is sorta reposting but I want to simplify the issue a bit. Take
the following script:
function replacemain(s){
var x = document.images;
var y = document.images;
var pictemp = x.src;
x.src = y.src;
y.src = pictemp;
}
|
by: jalkadir |
last post by:
I am trying to find a way to remove the leading and tailing blanks from
a string.
What I have come up with is not doing the work as I expected; because
if the value I pass to the function is " string " the leading and
trailing blanks are not removed. What am I doing wrong?
trimIt( std::string s ) {
size_t offset = s.length();
// Trim leading spaces ???
s.erase( 0, s.find_first_not_of( "\t\n" ) );
|
by: Andreas Lauffer |
last post by:
Can anyone tell me advantages / disadvantages of DataDirect Server
Wire ODBC-driver?
Any experiences?
What about redistribution?
Andreas Lauffer, easySoft. GmbH, Germany
|
by: William Kossack |
last post by:
I have an Access table with one primary key and am attempting to update
a non-key field, using
UPDATE tblMethtest SET fev1timemeth = '' WHERE SID = '0041R';
When I do this, the field subsequently contains 5 blanks instead of the
zero-length string I tried to put into it. This problem occurs
regardless of whether I execute the SQL from within Cold Fusion or from
within Access as an Access query. The same problem occurs on any
non-key...
|
by: John Hoge |
last post by:
I have a regex "^\d{5}$" that does not allow blanks, but the
RegularExpressionValidator does not fire for empty fields. Is there a
way to make it do so? I would rather not include a separate
RequiredValidator for reasons of brevity and neatness.
Thanks,
John
| |
by: Registered User |
last post by:
Hi experts,
I'm trying to write a program that replaces two or more consecutive
blanks in a string by a single blank.
Here's what I did:
#include <stdio.h>
#include <string.h>
#define MAX 80
|
by: Diego F. |
last post by:
Hi all.
I have an application that receives a message from a socket in an array from
a certain size. As the array size may be longer that the message received,
the end of the array has blank characters.
I use the System.Text.Encoding.ASCII.GetString method to convert to string
and insert in a database. The problem is that in the database the blanks are
inserted as well. How can I remove the blanks before inserting in the
database?
|
by: Hans Terlouw |
last post by:
Hi,
When trying to wrap C code using Pyrex, I encountered a strange problem with a
piece of pure Python code. I tried to isolate the problem. The following code
causes Pyrex to generate C code which gcc cannot compile:
class Axis:
axtype = "unknown type of axis"
def __init__(self):
|
by: downwitch |
last post by:
I have the strangest error, and wonder if anyone else has seen it. I'm
using ADODB to return a set of SQL Server 2005 records via ODBC. If I
open the recordset this way
With cmd
.CommandType = adCmdStoredProc
.CommandText = "dbo.spMyProc"
Set prm = .CreateParameter("@ID", adInteger,
Value:=plngID)
.Parameters.Append prm
|
by: eBob.com |
last post by:
I have a RichTextBox in which I'd like blanks to appear different from
nothing. Imagine a file which does not fill up the RTB. You can't tell how
many, if any, blanks might follow the last visible, i.e. non-whitespace,
character. I thought that I could set the BackColor of the RTB to LightGray
and then the blanks would show up as white. But instead the characters show
up on a LightGray background and the blanks, of course, show up as...
|
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...
| |
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,...
|
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...
|
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...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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();...
|
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...
| |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |