Database

14-Apr-15 14:20

I'm converting some old CDao classes to ADO (ODBC) for Access database handling. Part of my code copies a table record from one database to another. When I do the CRecordset::Update I get a CDBException that completely unhelpfully tells me:

C++

m_strError  "String data, right truncated 
m_strStateNativeOrigin  "State:22001,Native:31,Origin:[Microsoft][ODBC Microsoft Access Driver]

Is there any way to get my code to tell me which field(s) is(are) causing the problem?

Mycroft Holmes14-Apr-15 15:11

14-Apr-15 15:11

Kyudos wrote:
right truncated

I would check the length of everything, data, parameter, target field in the table.

Never underestimate the power of human stupidity
RAH

Kyudos14-Apr-15 15:27

14-Apr-15 15:27

I tried that...I can't find it! Sigh | :sigh:

Surely the driver must 'know' where this happens - why can't it just tell me? Roll eyes | :rolleyes:

Mycroft Holmes14-Apr-15 16:19

14-Apr-15 16:19

It is the same with SQL Server and has always been an irritant. With SQL Server you have sql profiler and you can trap the actual statement passed to the database including data. You can then manually execute the command in management studio. This gives you a more detailed error response and you can use the mark I eyeball to inspect the data.

I know you can execute sql strings in Access but I do not know where to trap the command passed to the database from the client.

I would strongly suggest moving the database from Access to SQL server if possible.

Never underestimate the power of human stupidity
RAH

Kyudos14-Apr-15 16:41

14-Apr-15 16:41

Mycroft Holmes wrote:
I would strongly suggest moving the database from Access to SQL server if possible.

That's impractical unfortunately.

I've checked all the text field member lengths before and after the Update, they both match each other and the database definition. The are no problems in DoFieldExchange. I don't know what to do next...

Kyudos14-Apr-15 17:02

14-Apr-15 17:02

Hah!

My fault of course - I was checking the wrong database definition - I had a field the wrong length!

oops!

Mycroft Holmes14-Apr-15 18:37

How to remove a 1000 seperator from a number

14-Apr-15 18:37

Yah, done that well... yesterday actually!

Never underestimate the power of human stupidity
RAH

Ambertje14-Apr-15 1:35

Ambertje

14-Apr-15 1:35

Hello everyone,

I would like to know if there is a function that can get rid of a 1000 seperator.

My Source data looks like this
1.676
3.349
109
58
70
1.887

I would like it to be like this:
1676
3349
109
58
70
1887

Does anyone know how I can fix this in my following statement please?

, CASE COALESCE(SHIPPED_VAL_MONTH, '') WHEN '' THEN 0 ELSE CAST(SHIPPED_VAL_MONTH as decimal(18,2)) END AS SHIPPED_VAL_MONTH

Kind regards,Ambertje

Re: How to remove a 1000 seperator from a number

Jörgen Andersson14-Apr-15 2:30

Jörgen Andersson

14-Apr-15 2:30

From sqlservercentral.
Create a UDF and put this in it:

SQL

WHILE PATINDEX('%[^0-9]%',@string) <> 0
    SET @string = STUFF(@string,PATINDEX('%[^0-9]%',@string),1,'')
SELECT @string

Wrong is evil and must be defeated. - Jeff Ello

Re: How to remove a 1000 seperator from a number

Ambertje14-Apr-15 3:04

Ambertje

14-Apr-15 3:04

Hello Jörgen,

Can you help me to create such a User defined function for my case please?

I have little experiece with writing functions.

Kind regards,
Ambertje

Re: How to remove a 1000 seperator from a number

Mycroft Holmes14-Apr-15 15:15

how to write xml code to manually create pdf without using third party in oracle apex

14-Apr-15 15:15

You are going to get better value out of an article than a forum post, there is even one from CP in these results[^]

Ambertje wrote:
help me to create such a User defined function

That is not how the site works, we help you to learn how to create the functions, there are other sites that will do the job for you.

Never underestimate the power of human stupidity
RAH

Member 1159668313-Apr-15 20:28

Member 11596683

13-Apr-15 20:28

plz help me to create pdf from xml code manually

VB.NET MYSQL loop through records while adding

Pauls Pauls13-Apr-15 10:40

13-Apr-15 10:40

i have a table with students marks records which contains the data as follows:

admno subjectGroup Exam subject marks
4719 GROUP I CAT-01 ENGLISH 45
4719 GROUP I CAT-01 KISWAHILI 78
4719 GROUP II CAT-01 CHEMISTRY 67
4719 GROUP II CAT-01 BIOLOGY 45
4719 GROUP II CAT-01 PHYSICS 45
4719 GROUP I CAT-01 MATHEMATICS 90
4720 GROUP I CAT-01 ENGLISH 67
4720 GROUP I CAT-01 KISWAHILI 61
4720 GROUP I CAT-01 MATHEMATICS 77
4721 GROUP I CAT-01 ENGLISH 81
4722 GROUP I CAT-01 KISWAHILI 62
4723 GROUP I CAT-01 ENGLISH 89
4724 GROUP I CAT-01 KISWAHILI 63
4726 GROUP I CAT-01 ENGLISH 78
4728 GROUP I CAT-01 ENGLISH 67
4730 GROUP I CAT-01 KISWAHILI 81
4734 GROUP I CAT-01 MATHEMATICS 56

i need to add marks belonging to a particular student(admno) based on the following criteria:
for each student;
1. select 3 group I subjects
2. select the best 2 group II subjects
...kindly assist

modified 13-Apr-15 16:50pm.

ZurdoDev13-Apr-15 11:09

ZurdoDev

13-Apr-15 11:09

What is your question?

There are only 10 types of people in the world, those who understand binary and those who don't.

Pauls Pauls13-Apr-15 11:48

13-Apr-15 11:48

summing up marks per student(admno) based on the conditions given

Mycroft Holmes13-Apr-15 15:21

13-Apr-15 15:21

Use a select query with a where clause on the subject group to get the group 1 students limit the output to 3 records (TSQL has a TOP function, not sure about MySQL)

For the second use the same query and change the where clause and the record limit. Add an order by on Marks to get the 2 records you need.

This is a microsoft answer, technically correct but does not meet you requirements which I suspect should have included - give me the codz!

Never underestimate the power of human stupidity
RAH

Pauls Pauls13-Apr-15 21:09

13-Apr-15 21:09

thanks for the answer....but that works well for a single student but for many students it add all marks of all students

Mycroft Holmes13-Apr-15 21:39

13-Apr-15 21:39

Ah my bad, I missed the add. You may need a nested select. First build your query to get the records you need and then wrap that in an aggregate query

SQL

select GroupID, sum(marks) 
from(select GroupID, marks 
From Table
Where Group = 'some code') X
group by GroupID

The query X gets the records you need and the outer query aggregates those records.

Never underestimate the power of human stupidity
RAH

Pauls Pauls14-Apr-15 2:47

PICTUREBOX IMAGE IN VB.NET

14-Apr-15 2:47

Thanks for the quick reply ...i have tried but could not really succeed. i managed the following

SELECT sAdmNo,SBGROUP,SUM(AVG) FROM (select sAdmNo,SBGroup, AVG
From (select sAdmNo,SBGroup, AVG FROM marks Where SBGroup = 'GROUP I' LIMIT 3)AS T
Where SBGroup = 'GROUP II' LIMIT 2)AS TT GROUP BY sAdmNo
...kindly elaborate on how i can add from both groups

Pauls Pauls13-Apr-15 1:18