Unrecognized Charaters
May 15, 2008
I was using an Hp ex470 single disk WHS when I started to recieve the data corruption bug. (http://www.wegotserved.co.uk/forums/index.php?showtopic=1872).
The data entered into the corrupted machine will insert unrecognized characters(square boxes) into an ntext column. (example : Coder213[][] is having big[][] problems.) It looks like everytime a character return is hit in the application the [][] show up.
Since the system had only been up for a week, I decided to move everything onto a new server 2003 box.(I already had an instance of the database before the box...so no problems) I had the workers copy and paste the data from the old app into the new app via the web interface. Guess what? [][] on the new box. I thought the unrecognized charters were copied from the interface..but now even new data being entered in is showing up with [][]. What is going on? I'm hoping one of you admin gurus can tell me to change a setting and everything will be ok.
The app runs fine and nothing really seems to be bothered by the blocks..but I don't like them. ..makes me nervous
Should I be concerned?
View 1 Replies
Nov 30, 2007
I need to create a function that will check data inputted by a user into a column anc check for special charaters. If any of these exist then block the insert.
Any help will be appreciated!
Paul
View 10 Replies
View Related
Oct 26, 2013
Due to limited number of characters..
no query cant be read by visual fox pro..due to error 36..
foxpro via mysql...here is the query..
SQLExec(nPayroll,"insert into py_abcdeeh(province,municipality,barangay,household_id,entry_id,lastname,firstname,middlename,ext_name,no_eli_for_educ_grant)
select m1.province,m1.municipality,m1.barangay,m1.household_id,m1.entry_id,m1.last_name,m1.first_name,m1.middle_name,m1.ext_name ,m2.count
[Code] ....
I did something like this but the query is not working anymore.. is there something wrong?? here is the query..
Query = ["insert into py_abcdeeh(province,municipality,barangay,household_id,entry_id,lastname,firstname,middlename,ext_name,no_eli_for_educ_grant)];
+[select m1.province,m1.municipality,m1.barangay,m1.household_id,m1.entry_id,m1.last_name,m1.first_name];
+[,m1.middle_name,m1.ext_name ,m2.count];
[Code] ....
VFP9.0 via MySQL 5.0
View 1 Replies
View Related
Feb 16, 2008
CSharp:SqlConnection Con = new SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance=True"); its give ErrorUnrecognized escape sequence
View 12 Replies
View Related
Sep 11, 2013
I've made a Report porting from SS2008 to SS2008.
In a textbox I use a:
Number -> Custom Format
like these:
=Code.FormatString(Fields!NumDecRpt.Value)
but gives me the "Unrecognized identifier" red squiggle.
My FormatString function (in the rdl file) is this:
Public Shared Function FormatString(ByVal Decimals as object) As String
dim format = "N0"
if not (Decimals is nothing or Decimals is System.DBNull.Value) then
dim decs as integer
decs = Convert.ToInt32(Decimals)
if decs>0 then
format = "N"+decs.ToString()
end if
end if
return format
End Function
What's wrong with this?
View 11 Replies
View Related
Nov 18, 2008
I wrong a custom code in my report - Public shared Function Myfunc and in the header textbox - I tried to reference this code = Code.Myfunc.... the Myfunc gives an error Unrecognized identifier.The code is written in the report properties = Code Tab.
View 4 Replies
View Related
