Topic: Phone book database

The Phone Book allows you to store basic contact information.


Download:
http://myvisualdatabase.com/database_ex … nebook.zip


Screenshots:
http://myvisualdatabase.com/database_examples/phonebook1.png

http://myvisualdatabase.com/database_examples/phonebook2.png

http://myvisualdatabase.com/database_examples/phonebook3.png

http://myvisualdatabase.com/database_examples/phonebook4.jpg

Dmitry.

Re: Phone book database

I am new to MVD.  When testing this sample phonebook application, I receive a SQL Syntax error if the last name entered in the textbox contains an apostrophe in a record being added (SQL INSERT).  MVD does not seem to generate this error if an apostrophe is added prior to a record update. 

I can also see from other forum posts that this topic has been discussed but I do not understand the preferred method for handling this common situation.  Should one always use custom script (SQL Insert) for any textbox linked to a database field?  Or... should one use a custom script to process the textbox before a MVD Saverecord?  And if it is the second option, what string functions are available in MVD from the SysUtils Unit?  "StringReplace" ??

Thank you.

Re: Phone book database

tbo
It's just bug of the old version, please download latest version then open this project using My Visual Database.

Dmitry.

Re: Phone book database

Hello Dmitry,

I downloaded the latest version but still get the SQL INSERT syntax error because of an apostrophe in the last name to be added.

Post's attachments

Attachment icon Phonebook.jpg 24.08 kb, 1 downloads since 2017-04-19 

Re: Phone book database

Hello.


You are right, again the bug.


Please download latest beta version, fixed:
https://www.dropbox.com/s/4sb2tk75rauoj … b.zip?dl=0

Dmitry.